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.
Modify this line and give *. If you have multiple interfaces on the
server, you can also specify a specific interface to be listened.
