Windows PostgreSQL monitoring configuration and remote connection

PostgreSQL server running on Windows, IP: 192.168.240.128

Configuration method:

1. Modify the server file your installation directory/postgresql/data/postgresql.conf file, change #listen_address = ' localhost ' to listen_address= ' * ‘。 Some default is to see the version.

2. Modify/Your installation directory/postgresql/data/gp_hba.conf file

In which you increase the IP of the client, as follows, note the last line:

# IPV4 Localconnections:

Host All 127.0.0.1/32 Trust

Host All 192.168.204.128/24 Trust

Increased server IP Listener 24 refers to the route trust refers to the connection method is not encrypted by default to MD5 encryption.

Description: Novice, simple record. Purely as a reference

Windows PostgreSQL monitoring configuration and remote connection