Workaround for Linux-mounted PostgreSQL problems with Windows or Linux

PostgreSQL server run on Linux, client installed on Windows or Linux, using Navicat connection, need to modify the server configuration

Configuration method:

1. Modify the server-side/etc/postgresql/9.3/main/postgresql.conf file to
#listen_address = ' localhost ' changed to
listen_address= ' * ' (postgresql.conf This file is changed to remove the # to change the localhost to *)

2. Modify the/opt/postgresql/data/gp_hba.conf file

In which you increase the IP of the client, as follows, note the last line:
# TYPE DATABASE USER cidr-address METHOD
# "Local" is for Unix domain sockets connections only
Local all All trust
# IPV4 Local connections:
Host All 127.0.0.1/32 Trust
# IPV6 Local connections:
Host all:: 1/128 Trust

# IPV4 Local connections:
Host all 192.168.201.114/32 Trust (or change to host all 0.0.0.0/0 trust, allow all IP connections )
(gp_hba.conf This file is changed at the bottom of the above two words!) ）

3. Restart the PG service
[Email protected] data]$/etc/init.d/postgresql restart

4. Now using the client connection is successful

Workaround for Linux-mounted PostgreSQL problems with Windows or Linux