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

3 votes101 views1 answer
Delete files with a certain extension recursively
Shell/Bash
-1 vote104 views2 answers
No space left on device
Shell/Bash
0 vote106 views1 answer
Running InfluxDB in a container over a network
Shell/Bash
0 vote96 views1 answer
How to run exe file with shell
Shell/Bash
1 vote97 views1 answer
How to close serveice on perticular port number
Shell/Bash
5 votes100 views1 answer
Install to current directory pip
Shell/Bash
0 vote170 views1 answer
Cli kill what is listening on port
Shell/Bash
0 vote106 views2 answers
Bash modify file text
Shell/Bash
0 vote143 views1 answer
Node_modules missing did you mean to install
Shell/Bash
0 vote102 views1 answer
Ubuntu add entry to /etc/apt/sources.list
Shell/Bash