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 vote124 views1 answer
Bash view the contents of a sqfs file
Shell/Bash
43 votes129 views6 answers
Kill a port windows
Shell/Bash
1 vote114 views1 answer
How to change read-only file system in linux
Shell/Bash
12 votes109 views3 answers
Git update all submodules
Shell/Bash
1 vote115 views2 answers
Iptable show all rules
Shell/Bash
0 vote121 views1 answer
Best source code editor
Shell/Bash
0 vote109 views1 answer
Install "repo"
Shell/Bash
0 vote128 views2 answers
Kali linux vdi
Shell/Bash
17 votes114 views4 answers
Cmd composer
Shell/Bash
0 vote127 views1 answer
Gtest filter command line
Shell/Bash