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

1 vote106 views1 answer
Gatsby.ps1 is not digitally signed
Shell/Bash
0 vote110 views2 answers
Best practices, build multi stage docker image securely
Shell/Bash
5 votes98 views2 answers
How to completely uninstall android studio mac
Shell/Bash
0 vote107 views1 answer
How to create a github repo on linux command line
Shell/Bash
0 vote96 views1 answer
Powershell grep for string in folder
Shell/Bash
0 vote107 views1 answer
List bluetooth devices
Shell/Bash
0 vote106 views1 answer
Du kan fixa tillbaka det med hjälp av GIT
Shell/Bash
0 vote104 views1 answer
Find directories not contain specific file
Shell/Bash
2 votes123 views1 answer
Ubuntu cleanup systemd journal
Shell/Bash
1 vote121 views2 answers
Install seaborn in anaconda
Shell/Bash