public inbox for [email protected]  

help / color / mirror / Atom feed

From: Tom Lane <[email protected]>
To: Jeff Janes <[email protected]>
Cc: pgsql-hackers <[email protected]>
Subject: Re: connection timeout hint
Date: Sun, 03 Dec 2023 22:10:11 -0500
Message-ID: <[email protected]> (raw)
In-Reply-To: <CAMkU=1zGu1AurGadiD78nK8JOJS=NVwQ4LBn=_Y-qUE6DUVfgw@mail.gmail.com>
References: <CAMkU=1zGu1AurGadiD78nK8JOJS=NVwQ4LBn=_Y-qUE6DUVfgw@mail.gmail.com>

Jeff Janes <[email protected]> writes:
> When one tries to connect to a server and port which is protected by a
> firewall, ones get messages like this:

> Unix:
> psql: error: connection to server at "192.168.0.26", port 5432 failed:
> Connection timed out
>         Is the server running on that host and accepting TCP/IP connections?

> Windows:
> psql: error: connection to server at "192.168.0.26", port 5432 failed:
> Connection timed out (0x0000274C/10060)
>         Is the server running on that host and accepting TCP/IP connections?

> But the hint given is unhelpful, and even positively misleading.

Well, maybe.  I think you're right that it would be useful to give
different hints for ETIMEDOUT and ECONNREFUSED, but sadly it seems
not uncommon for systems to just drop connection requests that
there's no listening process for.

Can we break down the possible cases any further?

* Target host doesn't exist or is down: could give ETIMEDOUT,
EHOSTDOWN, or EHOSTUNREACH.

* Host is up, but PG server is not running or not listening on that
socket: ideally ECONNREFUSED, but could be ETIMEDOUT if the local
firewall blocks it.

* Server is running, but firewall blocks reaching it: almost
certainly ETIMEDOUT.

Are there more cases?

The current hint is already reasonably on-point for EHOSTDOWN,
EHOSTUNREACH, ECONNREFUSED.  I agree it's too specific for
ETIMEDOUT, but what exactly would be a better message in view
of the multitude of possible causes?

> Is there some portable way to detect this cause of the connection problem
> (connection timeout)

No, I don't think so.  We have the kernel errno to work with
and little more.

			regards, tom lane

view thread (3+ messages)

reply

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: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: connection timeout hint
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox