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

2 votes239 views2 answers
Pip3.8 install ubuntu
Shell/Bash
1 vote211 views1 answer
Docker active log
Shell/Bash
0 vote177 views1 answer
How to enable git lol
Shell/Bash
15 votes215 views2 answers
Print env variables
Shell/Bash
4 votes219 views1 answer
Chrome skia shader compilation error
Shell/Bash
4 votes218 views6 answers
Aos library
Shell/Bash
2 votes225 views2 answers
Mac install gpg
Shell/Bash
0 vote217 views2 answers
Disable pre commit hook
Shell/Bash
0 vote226 views1 answer
Present working directory in shell script
Shell/Bash
0 vote214 views1 answer
Chown: invalid user: ‘www-data:www-data’
Shell/Bash