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 vote311 views1 answer
Depmod: not found
Shell/Bash
0 vote326 views1 answer
Bash variable lowercase
Shell/Bash
-1 vote311 views1 answer
Accessors are only available when targeting ECMAScript 5 and higher.
Shell/Bash
2 votes334 views1 answer
Get public ip linu
Shell/Bash
0 vote319 views1 answer
Install powershell 7
Shell/Bash
0 vote340 views1 answer
Github howto contribute fork 2 commits behind
Shell/Bash
0 vote361 views1 answer
Create cat document ubuntu
Shell/Bash
0 vote330 views2 answers
Install Mapproxy
Shell/Bash
0 vote363 views1 answer
Dhcp server
Shell/Bash
1 vote341 views1 answer
Install mongodb on manjaro linux
Shell/Bash