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

0 vote324 views2 answers
How to show freeswitch user accounts from fs_cli
Shell/Bash
2 votes335 views2 answers
Git delete branch upstream
Shell/Bash
0 vote281 views1 answer
Change default location screen mac
Shell/Bash
0 vote296 views2 answers
Git compare two branches with meld
Shell/Bash
0 vote312 views1 answer
Create a new branch and publish gitub
Shell/Bash
0 vote312 views1 answer
Subl command not found mac
Shell/Bash
0 vote313 views2 answers
Signing key android
Shell/Bash
0 vote312 views1 answer
Linux check if screen is running
Shell/Bash
0 vote309 views1 answer
Install walc whatsapp ubuntu
Shell/Bash
47 votes310 views2 answers
Stop a process running on a port ubuntu
Shell/Bash