Postgres 13.3 times out when attempting to connect via odbc & pgAdmin4 - Mailing list pgsql-admin

From Kevin Struckhoff
Subject Postgres 13.3 times out when attempting to connect via odbc & pgAdmin4
Date
Msg-id 1671906036.754266.1626734918424@mail.yahoo.com
Whole thread Raw
Responses Re: Postgres 13.3 times out when attempting to connect via odbc & pgAdmin4
List pgsql-admin
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

pgsql-admin by date:

Previous
From: hubert depesz lubaczewski
Date:
Subject: Re: Log zipping
Next
From: Yambu
Date:
Subject: postgresql.auto.conf