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

2 votes303 views1 answer
How to install keras ocr
Shell/Bash
0 vote263 views1 answer
Django flush sessions on server startup
Shell/Bash
3 votes276 views3 answers
Kubectl delete all
Shell/Bash
4 votes289 views3 answers
How to make ubuntu faster
Shell/Bash
1 vote277 views1 answer
Creating copy of a branch
Shell/Bash
0 vote296 views1 answer
Platform CLI
Shell/Bash
3 votes286 views3 answers
Free up space ubuntu
Shell/Bash
2 votes262 views1 answer
Vim tab 2 spaces
Shell/Bash
0 vote280 views2 answers
How to collect values from each iteration of a loop and save them bash
Shell/Bash
0 vote255 views1 answer
Linux print to pdf command line
Shell/Bash