Re: could not create socket for statistics collector: Protocol not supported - Mailing list pgsql-general

From Tom Lane
Subject Re: could not create socket for statistics collector: Protocol not supported
Date
Msg-id 26635.1096294774@sss.pgh.pa.us
Whole thread Raw
In response to could not create socket for statistics collector: Protocol not supported  ("Chris" <chris@paymentonline.com>)
Responses Re: could not create socket for statistics collector: Protocol not supported  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
"Chris" <chris@paymentonline.com> writes:
> I'm a little confused about why I am getting this.  I was reading a message
> from Tom earlier that said it was because postgresql could not bind to
> localhost, but the statistics collector is running and localhost does
> resolve to 127.0.0.1.

"Protocol not supported" suggests to me that getaddrinfo is returning an
IPv6 address for localhost when your kernel only supports IPv4 (or
possibly vice versa, but that seems much less likely).  You didn't give
enough detail to help in explaining why that might happen...

> I do see a lot of failed connection attempts to port 53 from
> postgres.

If you are intending to run without DNS, then you need to create or
adjust your /etc/resolv.conf file to say so.

            regards, tom lane

pgsql-general by date:

Previous
From: Federico Balbi
Date:
Subject: Re: proxying connections
Next
From: Tom Lane
Date:
Subject: Re: could not create socket for statistics collector: Protocol not supported