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

20 votes408 views6 answers
Extract tar
Shell/Bash
0 vote371 views1 answer
Display settings ubuntu 20.04 in right side
Shell/Bash
16 votes371 views3 answers
Linux replace string in files recursively
Shell/Bash
1 vote376 views1 answer
Kill port from terminal on mac
Shell/Bash
3 votes409 views3 answers
Ffmpeg download hls to mp4 with token
Shell/Bash
5 votes367 views2 answers
Elasticsearch list indexes
Shell/Bash
1 vote430 views1 answer
Setremotelogin: Turning Remote Login on or off requires Full Disk Access privileges.
Shell/Bash
1 vote347 views2 answers
How to check how many files are in a folder linux
Shell/Bash
2 votes344 views1 answer
Ubuntu du sort by dir size
Shell/Bash
2 votes373 views1 answer
Uninstall Expo CLI
Shell/Bash