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 vote152 views1 answer
Create private repository github command line
Shell/Bash
2 votes132 views1 answer
Git list all global aliases
Shell/Bash
13 votes143 views2 answers
Snap install microsoft teams
Shell/Bash
1 vote124 views1 answer
Sudo add permissions to user
Shell/Bash
7 votes123 views2 answers
Git checkout -f
Shell/Bash
0 vote137 views1 answer
Powershell list usb devices
Shell/Bash
0 vote183 views1 answer
Export SSH Auth Key
Shell/Bash
12 votes191 views5 answers
Wsl ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Shell/Bash
14 votes131 views3 answers
Installer microsoft teams ubuntu
Shell/Bash
1 vote130 views3 answers
Npm link
Shell/Bash