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

3 votes229 views3 answers
How to check free space in linux
Shell/Bash
9 votes225 views6 answers
Bash replace string
Shell/Bash
0 vote214 views1 answer
Restart webmin
Shell/Bash
0 vote230 views1 answer
R installation on ubuntu
Shell/Bash
53 votes225 views6 answers
Docker stop all containers
Shell/Bash
0 vote229 views1 answer
How to clear mouse marks in kubuntu
Shell/Bash
73 votes216 views4 answers
Git pull and overwrite
Shell/Bash
0 vote224 views1 answer
Set music cover image linux
Shell/Bash
0 vote218 views2 answers
Bash count occurrences of string in array
Shell/Bash
6 votes223 views6 answers
Add ssh key to github
Shell/Bash