enable Remote TCP conection in PostGres

1. By default, RemoteTCP connection is not enabled in PostGres. Default behavior is to listen forTCP/IP connections only on the local loopback address localhost. Therefore weneed to modify pg_hba.conf File to enable remoteaccess in PostGres at C:\Program Files\PostGresSQL\9.3\data(Example for PG version 9.3). 

And another thing to modify at

On the PostgreSQL database server, by default, the listen address will be localhost in the postgresql.conf file as shown below.

# grep listen /var/lib/pgsql/data/postgresql.conf
listen_addresses = 'localhost'

Modify this line and give *. If you have multiple interfaces on the server, you can also specify a specific interface to be listened.

# grep listen /var/lib/pgsql/data/postgresql.conf
listen_addresses = '*'

转载于:https://blog.51cto.com/huifu/1547705