天天看点

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.

Modify this line and give *. If you have multiple interfaces on the

server, you can also specify a specific interface to be listened.

enable Remote TCP conection in PostGres

继续阅读