Skip site navigation (1) Skip section navigation (2)

Re: Establishing remote connections is slow

From: Craig James <cjames(at)emolecules(dot)com>
To: Mindaugas Žakšauskas <mindas(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Establishing remote connections is slow
Date: 2012-01-17 21:04:46
Message-ID: (view raw or whole thread)
Lists: pgsql-admin
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.
> Regards,
> Mindaugas
> --
> 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 GovindassamyDate: 2012-01-17 21:37:51
Subject: Re: PG synchronous replication and unresponsive slave
Previous:From: LukasDate: 2012-01-17 20:51:38
Subject: Re: Establishing remote connections is slow

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group