I have listen_addresses set to '*' in postgresql.conf. The 1st entry below didn't help:
#listen_addresses = '192.168.56.101, localhost' # what IP address(es) to listen on; listen_addresses = '*'
in the pg_hba.conf file I added the 3rd line below, since I've assigned a static IP address to the CentOS server:
# IPv4 local connections: host all all 127.0.0.1/32 scram-sha-256 host all all 192.168.56.101/32 trust
Changing the IP number to 192.168.56.1/24 didn't help either, as expected I think.
I have Postgres 12. running on another VM and I had no trouble connecting using odbc and pgAdmin4.
Not sure what may have changed between the 2 versions to bring out this error.
The one thing I have noticed on 13.3 is that it now parses the listen_addresses = '192.168.56.101, localhost' string correctly. When I used this setting it opened port 5432 for both the static ip and 127.0.0.1. In 12.7, only the port 1st ip number would be opened. With the static IP listed first, postmaster wouldn't start automatically and if localhost was first, I couldn;t use odbc, etc.
