If you want to use Navicat manage your PostgreSQL, open the remote connect is necessary:
- Modify the /data/pgsql/pg_hba.conf
Add a line to pg_hba.conf
host all all 0.0.0.0/0 md5
Modify the /data/pgsql/postgresql.conf
#listen_addresses = 'localhost'
listen_addresses = '*'
- Restart the PostgreSQL
systemctl restart postgresql-11.service