Re: postmaster / resolv.conf / dns problem

From: Richard Huxton <dev(at)archonet(dot)com>
To: Cott Lang <cott(at)internetstaff(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-general(at)postgresql(dot)org
Subject: Re: postmaster / resolv.conf / dns problem
Date: 2005-12-02 09:14:52
Message-ID: 4390108C.60904@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Cott Lang wrote:
>>> Within 5 minutes, one server would not accept new remote connections. I
>>> could log in fine w/ psql locally.
>> This is pretty bizarre ... offhand I would not have thought that the
>> postmaster depended on DNS service at all. Were you maybe using DNS
>> names instead of IP addresses in pg_hba.conf? What exactly does
>> "would not accept" mean --- what was the exact error message,
>> and was there anything in the postmaster log?
>
>
> I'm using only IP addresses in pg_hba.conf.
>
> There was nothing in the postmaster log indicating a problem.
>
> The only thing I saw strange was multiple postmasters spawning and
> disappearing.
>
> The errors I got in the JDBC drivers was the connection pool timing out
> trying to get a connection, so it's possible they were working, just
> taking horribly long to connect. Timeouts for Nagios monitoring PG was
> 10 seconds; pools were 20 seconds. In three years, I've probably seen 3
> time outs. :)

Could it be name-lookups for logging purposes? I've been caught out by
that elsewhere.

--
Richard Huxton
Archonet Ltd

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Francesco Formenti - TVBLOB S.r.l. 2005-12-02 10:51:35 deadlock on the same relation
Previous Message Richard Huxton 2005-12-02 09:12:21 Re: PostgresSQL Halting System Boot