Enable remote access to PostgreSQL

There are few steps:

• Alow firewall for pgsql port and target IP 
• Enable client authentication (pg_hba.conf)
• host all all 10.10.29.0/24 trust
• Allow TCP/IP socket (postgresql.conf)
• listen_addresses='*'
• for version upto 7.x use tcpip_socket = true

refs:

http://www.cyberciti.biz/tips/postgres-allow-remote-access-tcp-connection.html