From: Kevin Struckhoff <kevinstruckhoff@yahoo.com>
To: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Subject: Postgres 13.3 times out when attempting to connect via odbc & pgAdmin4
Date: Mon, 19 Jul 2021 22:48:38 +0000 (UTC)
Message-ID: <1671906036.754266.1626734918424@mail.yahoo.com> (raw)
References: <1671906036.754266.1626734918424.ref@mail.yahoo.com>
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/postmastertcp6 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: kevinstruckhoff@yahoo.com, pgsql-admin@lists.postgresql.org
Subject: Re: Postgres 13.3 times out when attempting to connect via odbc & pgAdmin4
In-Reply-To: <1671906036.754266.1626734918424@mail.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox