Allow remote access to postgres via username and password

gistfile1.txt

1) in file /var/lib/pgsql/9.3/data/postgresql.conf change the default value 'localhost' to '*' (all) as shown

listen_addresses = '*'

2) in file /var/lib/pgsql/9.3/data/pg_hba.conf add line:

host   all             all             all			password

3) if it still does not work, you bet it's iptables fault. so either stop it temporarily to verify this or add an exception for port 5432

see this: http://www.cyberciti.biz/tips/howto-iptables-postgresql-open-port.html

Thanks 7u7