From: Kevin Struckhoff <kevinstruckhoff@yahoo.com>
To: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
To: Ron <ronljohnsonjr@gmail.com>
Subject: Re: Postgres 13.3 times out when attempting to connect via odbc & pgAdmin4
Date: Wed, 21 Jul 2021 17:57:44 +0000 (UTC)
Message-ID: <940545580.1388617.1626890264641@mail.yahoo.com> (raw)
In-Reply-To: <012581cb-993e-651d-77a2-afaa30a05a29@gmail.com>
References: <1671906036.754266.1626734918424.ref@mail.yahoo.com>
<1671906036.754266.1626734918424@mail.yahoo.com>
<CAMkU=1zbw6d4CF+0hJXRLd4kb7o5BuY+Vr8t=1Gk-fyphb42Kg@mail.gmail.com>
<1121133744.303360.1626822351105@mail.yahoo.com>
<012581cb-993e-651d-77a2-afaa30a05a29@gmail.com>
using netstat -tlpn:
tcp 0 0 127.0.0.1:5432 0.0.0.0:* LISTEN 1142/postmaster
tcp 0 0 192.168.56.101:5432 0.0.0.0:* LISTEN 1142/postmaster
tcp6 0 0 ::1:5432 :::* LISTEN 1142/postmaster
telnettting to 5432 fails.
Ports 22 and 9090 are open/listening and telnetting just fine. The problem must be on the Win 10 side.
Thanks. Kevin
On Tuesday, July 20, 2021, 5:49:59 PM PDT, Ron <ronljohnsonjr@gmail.com> wrote:
- run netcat to ee if postgres is listening on port 5432.
- then telnet to port 5432 to see if it's open.
On 7/20/21 6:05 PM, Kevin Struckhoff wrote:
I'm running Oracle VBox 6.1. What doesn't make sense is that I can connect via putty, WinSCP and even at port 9090 for the CentOS web client (cockpit) using the static IP address.
I suspect there's a bug in VBox, because my other VM uses just a single network adaptor set to Bridged mode and it connects just fine. However, it only works at home and not on the road. Hence the need for a static IP.
Thanks. Kevin
On Tuesday, July 20, 2021, 11:02:31 AM PDT, Jeff Janes <jeff.janes@gmail.com> wrote:
On Mon, Jul 19, 2021 at 6:48 PM Kevin Struckhoff <kevinstruckhoff@yahoo.com> wrote:
Hi,
Just installed 13.3 on CentOS 8 runnning on a VM on my win 10 laptop.
What is your VM software?
I am getting an error while running the odbc connection test:
could not connect to server: connection timed out.
Connection timeouts are almost always caused by firewalls or gateways. It can't be due to pg_hba, as you are not getting far enough for that to kick in yet.
Cheers,
Jeff
--
Angular momentum makes the world go 'round.
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, ronljohnsonjr@gmail.com
Subject: Re: Postgres 13.3 times out when attempting to connect via odbc & pgAdmin4
In-Reply-To: <940545580.1388617.1626890264641@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