PostgreSQL allows remote access to configuration modifications

1, resolve cannot connect remote PostgreSQL:

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.

2, after the modification is complete restart:

/postgresql/9.3/bin/pg_ctl stop

/postgresql/9.3/bin/pg_ctl start

Pg_ctl:no database directory specified and environment variable PGDATA unset are set under environment variables if reported during startup

Pgdata=/postgresql/9.3/data
Export PGDATA

If you report CST log:could not create IPV6 socket: Address family not supported by protocol, ignore, do not affect connection

PostgreSQL allows remote access to configuration modifications