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 vote189 views1 answer
Install command-line ipfs
Shell/Bash
0 vote217 views1 answer
Uninstall lubuntu
Shell/Bash
-1 vote192 views1 answer
Wsl2 file
Shell/Bash
0 vote182 views2 answers
Managing apache in freebsd
Shell/Bash
2 votes196 views1 answer
Arduino permission denied
Shell/Bash
25 votes207 views6 answers
Check ram on linux
Shell/Bash
0 vote208 views1 answer
Install siege on mac
Shell/Bash
0 vote192 views1 answer
Libcuda.so.1: cannot open shared object file: No such file or directory
Shell/Bash
0 vote187 views1 answer
How to mount device linux
Shell/Bash
3 votes190 views1 answer
Nginx stop commands
Shell/Bash