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

12 votes159 views2 answers
How to remove node_modules from git
Shell/Bash
0 vote155 views1 answer
Checking dependencies BASH
Shell/Bash
0 vote152 views1 answer
Git clone only single file
Shell/Bash
0 vote154 views3 answers
Connection Log connecting to sesman ip l27.0.0.1 port 3350 sesman connect ok sending login info to session manager, please wait... login failed for display 0
Shell/Bash
0 vote139 views1 answer
Sublime Text install Ubuntu/Debian
Shell/Bash
19 votes138 views2 answers
Github set branch upstream
Shell/Bash
0 vote147 views1 answer
Pip install google vision
Shell/Bash
15 votes148 views2 answers
Git ignore permission changes
Shell/Bash
1 vote139 views1 answer
Unit mongodb.service could not be found ubuntu
Shell/Bash
0 vote142 views1 answer
Debian get minor version
Shell/Bash