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 vote179 views1 answer
Verify dart on linux
Shell/Bash
0 vote183 views1 answer
Manjaro nvidia driver
Shell/Bash
2 votes240 views1 answer
Mac anydesk start at login
Shell/Bash
2 votes171 views1 answer
Bash folder size
Shell/Bash
0 vote180 views1 answer
Clear arp table ubuntu]
Shell/Bash
1 vote189 views1 answer
Jscore
Shell/Bash
1 vote179 views1 answer
Docker-machine create digitalocean
Shell/Bash
0 vote199 views1 answer
Conda install transformers
Shell/Bash
1 vote183 views1 answer
Linux dir one line
Shell/Bash
0 vote203 views1 answer
How to kill a program in lunux mint
Shell/Bash