Re: duplicate connection failure messages

Bruce Momjian wrote:
> Peter Eisentraut wrote:
> > On fre, 2010-11-26 at 13:27 -0500, Bruce Momjian wrote:
> > > Peter Eisentraut wrote:
> > > > On fre, 2010-11-26 at 11:53 -0500, Bruce Momjian wrote:
> > > > > OK, I updated the code to always use cur_addr in the code --- let me
> > > > > know if that doesn't fix it.
> > > >
> > > > Now it's even more wrong:
> > > >
> > > > 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" (232.106.56.8) and accepting
> > > > TCP/IP connections on port 55555?
> > >
> > > Yep, even worse. I have applied the attached patch, which gives me the
> > > right IPv4 value. I can't test IPv6.
> >
> > We're back to
> >
> > 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" (127.0.0.1) and accepting
> > TCP/IP connections on port 55555?
>
> OK, good. :-O I just realize I can easily test this on Ubuntu so let
> me get that working now.

OK, Tom and I both found the problem --- our data type assumed INET6 was
INET + 1, while libc had other ideas. Here is the new, I guess correct,
output from Ubuntu:

$ /usr/local/pgsql/bin/psql -h localhost test
psql: could not connect to server: Connection refused
Is the server running on host "localhost" (::) and accepting
TCP/IP connections on port 5432?
could not connect to server: Connection refused
Is the server running on host "localhost" (127.0.0.1) and
accepting
TCP/IP connections on port 5432?

Is "::" correct?

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ It's impossible for everything to be true. +