PostgreSQL Remote Access Enabled

Preamble : Only the remote permissions for the specified IP of PostgreSQL are configured, and later a client wants to see the data through a remote connection, but her IP is constantly postgre, causing me to re-set it every time, and finally find a way Now make the following records:

For Windows Services only

Locate the pg_hba.conf configuration file, and the path is normally under the data directory of the Postgre installation directory

C:\Program Files\postgresql\9.3\data

Open, make the following configuration

# IPV4 Local connections:host    all             127.0.0.1/32            md5host all             0.0.0.0/0            Md5

The first behavior specifies that IP specifies that the second behavior of all IPs, in general, is not to turn on all IP rights because of security.

It is also important to note that the postgresql.conf file of the same directory

listen_addresses = ' * ' # What IP address (es) to listen on;

PostgreSQL Remote Access Enabled