Postgre create user

#!/usr/bin/env bash
# to execute, open a terminal in directory and run chmod +x <filename>.sh

user="{user name}"
database="{database name}"
args="--host=localhost --dbname=$database --username=$user"

echo -e "Creating user $user.....\n"
sudo -u postgres createuser --createdb --pwprompt $user
echo -e "User Created!\n"

echo -e "Creating database $database.....\n"
sudo -u postgres createdb --owner=$user $database
echo -e "Database Created!\n"
echo -e "Restarting server and starting psql....\n"
sudo service postgresql restart

psql $args

Similar codes

9 votes284 views2 answers
Killing port using npm cli
Shell/Bash
0 vote294 views1 answer
If data is not available column header should print in output file in powershell
Shell/Bash
0 vote311 views1 answer
Gnat
Shell/Bash
2 votes313 views1 answer
Npm install --save-dev shortcut
Shell/Bash
0 vote297 views2 answers
How to allow traffic on port 8080 in centos 7
Shell/Bash
2 votes318 views1 answer
How to install imagemagick in linux
Shell/Bash
0 vote314 views2 answers
Best ide editor
Shell/Bash
6 votes300 views2 answers
Laravel Rolling Back Migrations
Shell/Bash
1 vote292 views1 answer
How to download youtube vides on linux
Shell/Bash
2 votes306 views2 answers
Dconf editor ubuntu 20.04
Shell/Bash