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

20 votes129 views4 answers
Git flow hotfix
Shell/Bash
0 vote127 views1 answer
Install a package that is not in conda
Shell/Bash
1 vote133 views1 answer
How to grep lines before a pattern
Shell/Bash
27 votes121 views1 answer
Cancel merging
Shell/Bash
0 vote126 views1 answer
Reattach to screen
Shell/Bash
0 vote121 views1 answer
How to install paint.net on linux
Shell/Bash
0 vote120 views1 answer
How to check if your linux Server Is Under DDoS Attack
Shell/Bash
1 vote141 views1 answer
Ge in shell script
Shell/Bash
3 votes125 views1 answer
Npm to yarn migration
Shell/Bash
2 votes194 views3 answers
Backup postgres database docker
Shell/Bash