Pasted

Check if postgresql is running
===
/etc/rc.d/init.d/postgresql status
/etc/rc.d/init.d/postgresql-9.3 status
 
Find all processes running under postgres user
===
ps -f -u postgres
ps auxw | grep post
 
Show the TCP/IP addresses and ports PostgreSQL is listening on
===
lsof -n -u posgres | grep LISTEN
netstat -ltnp | grep postgres
 
A failure message suggesting that another postmaster is already running should be checked carefully, for example by using the command
===
ps ax | grep postmaster
ps -ef | grep postmaster
 
Grand sudo access
===
visudo
 
Secure access by disabling root and giving your Linux user account an ssh key
===
On remote terminal:
cd (homedir)
mkdir .ssh
touch .ssh/authorized_keys
on remote machine:
cat .ssh/id_rsa.pub
copy
On remote terminal:
paste key into .ssh/authorized_keys
Logon as root:
sudo su -
mv .ssh/authorized_keys .ssh/authorized_keys_OLD
 
Edit pg_hba.conf
===
vi /etc/postgresql/9.3/pg_hba.conf