PostgreSQL10 configuration remote connection
psql –– version
centos7.3
1, open the corresponding Firewall port, allow port 5432
2, access permission configuration /etc/postgresql/10/main/
under pg_hba.conf
# TYPE DATABASE USER ADDRESS METHOD # "local" is for Unix domain socket connections only local all all peer # IPv4 local connections: host all all 127.0.0.1/32 ident # IPv6 local connections: host all all ::1/128 ident # Allow replication connections from localhost, by a user with the # replication privilege. #local replication all peer #host replication all 127.0.0.1/32 ident #host replication all ::1/128 ident host all all 0.0.0.0/0 md5
3, monitoring machine configuration
3, monitoring machine configuration postgresql.conf under /etc/postgresql/10/main/
postgresql.conf
< /h3>
#-Connection Settings- listen_addresses = ‘*‘ # what IP address(es) to listen on; # comma-separated list of addresses; # defaults to ‘localhost’; use ‘*’ for all # (change requires restart) #port = 5432 # (change requires restart)
centos6.8
The above files are in the path of /var/lib/pgsql/10/data/
Down
/etc/postgresql/10/main/
postgresql.conf
< /h3>
#-Connection Settings- listen_addresses = ‘*‘ # what IP address(es) to listen on; # comma-separated list of addresses; # defaults to ‘localhost’; use ‘*’ for all # (change requires restart) #port = 5432 # (change requires restart)
The above files are in the path of