PostgreSQL Remote Access

The default concept for PostgreSQL is to run on a local address and not allow external access.

If you want to access this excellent third-party software through Navicat for PostgreSQL, you need to make the following modifications:

First, start at an externally accessible address

 1   edit postgresql.conf files in the actual installation environment  2  vim/var /lib/pgsql/ 9.5 /data/postgresql.conf  3   modify  4  #listen_ addresses =  " localhost  "   # What IP address (es) to listen on;  5   is 
 6  7 listen_addresses = "  *   " #use  " *  "  for  all 

Second, increase remote access permissions

 1   edit pg_hba.conf  2  vim/var /lib/pgsql/9.5 /data/pg_hba.conf  3   in  4  # IPv4 local connections :  5  host all 127.0 . 0.1 /32   MD5  6   add this line below:  7  8  host all 0.0 . 0.0 /0  password 

This is the basic database configuration, and the rest is to configure the remote access users.

PostgreSQL Remote Access