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

17 votes288 views3 answers
Check postgres version in ubuntu
Shell/Bash
0 vote294 views1 answer
Phpinfo cli
Shell/Bash
1 vote283 views1 answer
K8 svc url
Shell/Bash
81 votes284 views6 answers
Node express
Shell/Bash
1 vote312 views1 answer
Github wiki link to another page
Shell/Bash
1 vote265 views1 answer
Bash try catch
Shell/Bash
5 votes282 views2 answers
Git checkout commit
Shell/Bash
1 vote273 views1 answer
Swapping of two numbers without using third variable in shell script
Shell/Bash
0 vote338 views1 answer
Grails environment variables ubuntu
Shell/Bash
3 votes293 views1 answer
Install c++ ubuntu
Shell/Bash