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 vote128 views9 answers
Ruby install on fedora
Shell/Bash
2 votes120 views2 answers
How to stop shutdown command windows 10
Shell/Bash
-1 vote114 views2 answers
Mongodb restart command ubuntu
Shell/Bash
0 vote119 views1 answer
How to close a programm in bash
Shell/Bash
0 vote123 views1 answer
How to check the requirement of a package in pip
Shell/Bash
3 votes175 views4 answers
Timestamp in bash
Shell/Bash
0 vote129 views1 answer
Linux ip route add
Shell/Bash
0 vote117 views1 answer
Android studio (not installed) windows
Shell/Bash
1 vote117 views1 answer
Online shell script compiler
Shell/Bash
7 votes134 views4 answers
Linux speed test
Shell/Bash