Postgres Install

sudo apt-get install -y postgresql

Setting up password for default user 'postgres'

sudo -u postgres psql -c "alter user postgres password 'postgres';"

sudo -u postgres will execute command as 'postgres' linux user

Create database user

sudo -u postgres PGPASSWORD=postgres psql -U postgres -d postgres -h localhost -c "CREATE USER <user_name> WITH PASSWORD '<password>'"

PGPASSWORD=postgres sets the environment variable for linux user 'postgres'

environment variables can be used to select default connection parameter values

Create database

sudo -u postgres PGPASSWORD=postgres psql -U postgres -d postgres -h localhost -c "CREATE DATABASE <database_name> WITH OWNER <database_user>"

Database backup/restore

sudo -u postgres pg_dump <database_name> > db.sql

sudo -u postgres psql -U postgres <database_name> < /path/to/db.sql

SQL Dump

pg_dump

pg_restore