Enable postgresql remote permissions and enable postgresql
Preface: Previously, only the remote permission of the specified IP address of postgresql will be configured. Later, a client wants to remotely connect to postgre and view data, but her IP address changes frequently, as a result, I had to re-set the settings every time, and finally found the method. Now I have made the following record:
For Windows Services only
FindPg_mirror.confConfiguration file. The path is generally under the data Directory of the postgre installation directory.
C: \ Program Files \ PostgreSQL \ 9.3 \ data
Open and configure
# IPv4 local connections: host all 127.0.0.1/32 md5host all 0.0.0.0/0 md5
The first action specifies the IP address, and the second action specifies all IP addresses. Generally, all IP address permissions are not enabled because of security.
In addition, you must note thatPostgresql. confFile
Listen_addresses = '*' # what IP address (es) to listen on;