Hi,
Just installed 13.3 on CentOS 8 runnning on a VM on my win 10 laptop. I am getting an error while running the odbc connection test:
could not connect to server: connection timed out.
This error occurs also with pAdmin4.5.5.
on the CentOS server, I can see the correct ports listening:
tcp 0 0 0.0.0.0:5432 0.0.0.0:* LISTEN 1154/postmaster
tcp6 0 0 :::5432 :::* LISTEN 1154/postmaster
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.
What am I missing here?
Thanks. Kevin