2012/1/17 Mindaugas Žakšauskas <mindas(at)gmail(dot)com>
> On Tue, Jan 17, 2012 at 7:23 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> > <..> Mindaugas, are you using SSL,
> > and if so can you turn it off and see whether things change?
> > (It should be safe to do so at least on the "localhost" connection,
> > even if you feel your network is insecure.)
> No, I am not using SSL; it is either disabled or the default setting
> is off anyway. This was one of the first things I have checked.
> Moreover, this would probably make it hard to explain why does it take
> no time to establish connections immediately after PostgreSQL restart
> and why it does it degrade later.
> To respond to previous emails - we tried doing DNS lookups against the
> client host and they took no time.
Try putting the hostnames and IP addresses in /etc/hosts ... first on the
server (for the client) and then on the client (for the server).
> Thanks for your ideas.
> Sent via pgsql-admin mailing list (pgsql-admin(at)postgresql(dot)org)
> To make changes to your subscription:
In response to
pgsql-admin by date
|Next:||From: Manoj Govindassamy||Date: 2012-01-17 21:37:51|
|Subject: Re: PG synchronous replication and unresponsive slave|
|Previous:||From: Lukas||Date: 2012-01-17 20:51:38|
|Subject: Re: Establishing remote connections is slow|