PostgreSQL configuration modifications that allow remote access

PostgreSQL allows remote access to configuration modifications

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 "*" and in 9.0 Windows Edition, the item configuration is "*" 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.

PostgreSQL configuration modifications that allow remote access