PostgreSQL Remote connection appears: Error connecting to server: Fatal error SSL shutdown pg_hba.conf record

Abnormal:

Solution:

[Email protected] ~]# vi/var/lib/pgsql/data/pg_hba.conf

# TYPE DATABASE USER cidr-ADDRESS method#"Local"Is forUnix domain Socket connections onlylocal All ident# IPv4 Local connection S:host All127.0.0.1/ +Identhost All10.10.46.1/ -MD5 # New Add # IPV6 local connections:host all::1/ -Ident

Note: If there is a listener exception, please modify

Vi

listen_addresses = ' * ' # What IP address (es) to listen on; Remove comments
# comma-separated List of addresses;
# defaults to ' localhost ', ' * ' = All
# (change requires restart)
Port = 5432 # (change requires restart) removing comments
#ssl_renegotiation_limit = 512MB # amount of data between renegotiations
Password_encryption = on # remove Comment