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 vote151 views1 answer
Install cpanm
Shell/Bash
3 votes159 views1 answer
Magento 2 file permission
Shell/Bash
4 votes147 views4 answers
Git remove tracked files without deleting
Shell/Bash
2 votes161 views2 answers
How to check if a commit is in a branch
Shell/Bash
0 vote154 views1 answer
Installing firebase libraries in apache cordova
Shell/Bash
0 vote153 views1 answer
Install lerna on Linux
Shell/Bash
0 vote149 views1 answer
Scp linux to mac
Shell/Bash
1 vote154 views1 answer
Tail log of spring boot service (linux)
Shell/Bash
0 vote170 views1 answer
Install docpars
Shell/Bash
0 vote109 views1 answer
Get info about an audio file ffmpeg
Shell/Bash