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 vote215 views1 answer
Remi repo
Shell/Bash
0 vote157 views1 answer
Rpi install chomedriver
Shell/Bash
4 votes173 views1 answer
Install heroku globally
Shell/Bash
0 vote196 views1 answer
Md5sum windows
Shell/Bash
0 vote149 views1 answer
Run ssh-agent
Shell/Bash
0 vote151 views1 answer
Minikube without sudo
Shell/Bash
1 vote157 views1 answer
Jest vscode autocomplete
Shell/Bash
0 vote218 views1 answer
How to know partition of current directory
Shell/Bash
0 vote179 views2 answers
Git checkout specific file types only
Shell/Bash
5 votes169 views2 answers
Psycopg2-binary install
Shell/Bash