duplicate connection failure messages

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: pgsql-hackers(at)postgresql(dot)org
Subject: duplicate connection failure messages
Date: 2010-10-13 19:21:02
Message-ID: 1286997662.4671.17.camel@vanquo.pezone.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

This surprised me:

psql -p 55555 -h localhost
psql: could not connect to server: Connection refused
Is the server running on host "localhost" and accepting
TCP/IP connections on port 55555?
could not connect to server: Connection refused
Is the server running on host "localhost" and accepting
TCP/IP connections on port 55555?

It shows the same error message twice. I can reproduce this back to PG
8.2.

It appears to have something to do with localhost resolving to an IPv4
and an IPv6 address, since it doesn't happen with other host names that
only resolve to one address. However, fe-connect.c claims:

/*
* Try to initiate a connection to one of the addresses
* returned by pg_getaddrinfo_all(). conn->addr_cur is the
* next one to try. We fail when we run out of addresses
* (reporting the error returned for the *last* alternative,
* which may not be what users expect :-().
*/

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Garick Hamlin 2010-10-13 19:24:54 Re: SQL command to edit postgresql.conf, with comments
Previous Message Kevin Grittner 2010-10-13 19:16:49 Re: leaky views, yet again