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 vote147 views1 answer
Compare local git branch with remote
Shell/Bash
6 votes134 views2 answers
Laravel Rolling Back Migrations
Shell/Bash
0 vote153 views2 answers
Gem install to a different directory linux
Shell/Bash
4 votes156 views2 answers
Remove a folder in linux command
Shell/Bash
0 vote127 views1 answer
Terraform remove from state
Shell/Bash
0 vote186 views1 answer
Add all the files to staging which will be then be added to the commit.
Shell/Bash
1 vote144 views1 answer
Connect ps4 controller to pc linux
Shell/Bash
0 vote135 views1 answer
Grab github api data using a curl command
Shell/Bash
0 vote145 views1 answer
How to boot from grub rescue
Shell/Bash
16 votes184 views3 answers
Docker rm all
Shell/Bash