PostgreSQL9 remote access settings

1. postgresql. conf

Set the value of listen_addresses in this file to "*". In Windows 9.0, this configuration is already "*" and does not need to be modified.

2. Pg_cmd.conf

Add the following configuration under the host all 127.0.0.1/32 md5 line of the configuration file, or directly change this line to the following configuration

Host all 0.0.0.0/0 md5

If you do not want to allow remote access from all IP addresses, you can set 0.0.0.0 in the preceding configuration item to a specific IP address.