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

1 vote201 views1 answer
How to download youtube vides on linux
Shell/Bash
5 votes193 views2 answers
Git checkout commit
Shell/Bash
0 vote205 views1 answer
Goodix debug linux
Shell/Bash
3 votes265 views2 answers
Install jdk linux
Shell/Bash
0 vote207 views1 answer
Docker push to private registry
Shell/Bash
10 votes197 views4 answers
Home directory of wsl
Shell/Bash
0 vote210 views1 answer
Compile protobufs to c code
Shell/Bash
0 vote198 views1 answer
Bash split pipe output by delimiter
Shell/Bash
0 vote204 views1 answer
Github pdftron
Shell/Bash
0 vote243 views1 answer
Verify large directory after copy files
Shell/Bash