Re: Cannot bind socket

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Suresh Gupta VG" <suresh(dot)g(at)zensar(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org, "Anupam Kumar" <anupam(dot)k(at)zensar(dot)com>
Subject: Re: Cannot bind socket
Date: 2008-01-18 15:42:04
Message-ID: 9103.1200670924@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

"Suresh Gupta VG" <suresh(dot)g(at)zensar(dot)com> writes:
> server starting
> bash-2.05$ LOG: could not bind socket for statistics collector: Cannot
> assign requested address
> LOG: trying another address for the statistics collector
> LOG: database system was shut down at 2008-01-18 16:06:04 AST

AFAICT you do not have a problem here. The database started up fine.

If you don't like the chatter in the log, fix your name resolution setup
(/etc/hosts or DNS) so that it doesn't return a non-working translation
of "localhost". It looks to me like it probably returns both IPv6 and
IPv4 translations when the kernel will only take one of them.

regards, tom lane

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2008-01-18 16:23:32 Re: more blob questions
Previous Message Milen A. Radev 2008-01-18 13:54:46 Re: select only user