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 vote208 views1 answer
Install ssl ubuntu
Shell/Bash
0 vote204 views1 answer
Github tips
Shell/Bash
1 vote203 views1 answer
How to connect to a git repo in cmd
Shell/Bash
1 vote196 views3 answers
Remove git proxy
Shell/Bash
0 vote200 views1 answer
Setup linux and chrome docker
Shell/Bash
0 vote192 views1 answer
Linkar repo en github
Shell/Bash
1 vote235 views1 answer
Install yacc on ubuntu
Shell/Bash
0 vote208 views2 answers
Not Found The requested URL was not found on this server. Apache/2.4.41 (Ubuntu) Server at localhost Port 80
Shell/Bash
1 vote207 views1 answer
Tried accessing the FileTransfer plugin but it's not installed.
Shell/Bash
0 vote170 views1 answer
Could not load reporter by name: mochawesome
Shell/Bash