PostgreSQL Remote Connection Configuration

PostgreSQL by default, remote Access does not succeed, and if you need to allow remote access, you need to modify two configuration files, as described below:

1.postgresql.conf

Set the Listen_addresses key value in the file to "*", which is already "*" in 9.0 Windows edition, without modification.

2.pg_hba.conf

Add the following configuration under the host all All 127.0.0.1/32 MD5 line of the configuration file, or modify the line directly to the following configuration

Host All 0.0.0.0/0 MD5

If you do not want to allow all IP remote access, you can set the 0.0.0.0 in the above configuration item to a specific IP value, such as:

Host All 192.168.1.0/24 MD5

Host All 192.168.1.0/32 Trust

Indicates that all hosts on the network segment 192.168.1.0 are allowed to access the database using all legitimate database user names and provide encrypted password authentication.

Where the number 24 is the subnet mask, which means that the 192.168.1.0--192.168.1.255 computer is allowed access!

PostgreSQL Remote Connection Configuration