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 vote322 views1 answer
Hadoop hive get time from timestamp
Shell/Bash
1 vote342 views1 answer
Ansible become_method sudo example
Shell/Bash
0 vote348 views1 answer
Error: Fetching /usr/local/Homebrew/Library/Taps/commands/homebrew-pup failed!
Shell/Bash
1 vote411 views1 answer
What is the plus (+) sign in permission in Linux ?
Shell/Bash
5 votes367 views2 answers
Could not connect to server: Connection refused Is the server running on host "localhost" (::1) and accepting TCP/IP connections on port 5432
Shell/Bash
1 vote358 views1 answer
Install rabbitmq on ubuntu 18.04
Shell/Bash
1 vote359 views1 answer
Git syntax
Shell/Bash
0 vote325 views2 answers
What is the use of bashrc file in linux
Shell/Bash
0 vote365 views4 answers
Rsync
Shell/Bash
19 votes355 views3 answers
Git flow init
Shell/Bash