postgresql

sudo -u postgres psql #This works only when pg_hba.conf is configured with value 'peer' for key 'method' for user 'postgres'.

postgres=#ALTER ROLE postgres WITH ENCRYPTED PASSWORD '<PASSWORD>'

OR,

postgres=#\q

listen_addresses = '*'

local   all             postgres                                md5      #To be changed from peer to md5   

host    all             all             192.168.56.0/78         md5

sudo /etc/init.d/postgresql restart

postgres=#\?          #Lists all commands and description..

postgres=#\list       #Lists databases in .

postgres=#\dt[S+]     #Lists all tables.

postgres=#create user <USER_NAME> with encrypted password '<PASSWORD>';

postgres=#grant all privileges on database <DB1,DB2..> to <USER_NAME>;

postgres=#\q          #To quit psql

postgres=#psql -U <USER_NAME> -d <ALLOWED_DATABASE_NAME> -hlocalhost;

postgres=#CREATE DATABASE "<NEW_NAME>" TEMPLATE "<EXISTING_NAME>"