Re: caracara failing to bind to localhost?

Lists: pgsql-hackers
From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: cbbrowne(at)ca(dot)afilias(dot)info
Cc: pgsql-hackers(at)postgreSQL(dot)org
Subject: caracara failing to bind to localhost?
Date: 2010-02-27 04:02:31
Message-ID: [email protected]
Views: Whole Thread | Raw Message | Download mbox | Resend email
Lists: pgsql-hackers

Buildfarm member caracara has been failing the last few days because of
this:

LOG: could not bind socket for statistics collector: Cannot assign requested address
LOG: disabling statistics collector for lack of working socket

That code hasn't changed recently, AFAIK, so I'm thinking something's
broken in the machine's environment. Any ideas?

regards, tom lane


From: "Dickson S(dot) Guedes" <listas(at)guedesoft(dot)net>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: cbbrowne(at)ca(dot)afilias(dot)info, pgsql-hackers(at)postgresql(dot)org
Subject: Re: caracara failing to bind to localhost?
Date: 2010-02-27 14:02:15
Message-ID: [email protected]
Views: Whole Thread | Raw Message | Download mbox | Resend email
Lists: pgsql-hackers

2010/2/27 Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>:
> Buildfarm member caracara has been failing the last few days because of
> this:
>
> LOG:  could not bind socket for statistics collector: Cannot assign requested address
> LOG:  disabling statistics collector for lack of working socket
>
> That code hasn't changed recently, AFAIK, so I'm thinking something's
> broken in the machine's environment.  Any ideas?

Firewall or that ipv6's issues when ::1 for localhost is enabled in
/etc/hosts or that cases when there is an ipv4 address and an ipv6
alias in the same eth0? Was the tcpip_socket variable changed on
caracara's host?

[]s
Dickson S. Guedes
mail/xmpp: guedes(at)guedesoft(dot)net - skype: guediz
http://guedesoft.net - http://www.postgresql.org.br


From: Christopher Browne <cbbrowne(at)ca(dot)afilias(dot)info>
To: "Dickson S(dot) Guedes" <listas(at)guedesoft(dot)net>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: caracara failing to bind to localhost?
Date: 2010-03-02 23:22:02
Message-ID: [email protected]
Views: Whole Thread | Raw Message | Download mbox | Resend email
Lists: pgsql-hackers

Dickson S. Guedes wrote:
> 2010/2/27 Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>:
>
>> Buildfarm member caracara has been failing the last few days because of
>> this:
>>
>> LOG: could not bind socket for statistics collector: Cannot assign requested address
>> LOG: disabling statistics collector for lack of working socket
>>
>> That code hasn't changed recently, AFAIK, so I'm thinking something's
>> broken in the machine's environment. Any ideas?
>>
>
> Firewall or that ipv6's issues when ::1 for localhost is enabled in
> /etc/hosts or that cases when there is an ipv4 address and an ipv6
> alias in the same eth0? Was the tcpip_socket variable changed on
> caracara's host?
>
> []s
> Dickson S. Guedes
> mail/xmpp: guedes(at)guedesoft(dot)net - skype: guediz
> http://guedesoft.net - http://www.postgresql.org.br
>
I had dropped an interface on my laptop...

"ifup lo" brought back the local loopback, thereby restoring 127.0.0.1,
so everything should work now. I hope... :-).