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: CAFwQ8rfzTLU=p7034RfLhbC2JeNeiPgbQPB2kPttL3cj6SeFEw@mail.gmail.com (view raw or flat)
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).

Craig


>
> Thanks for your ideas.
>
> Regards,
> Mindaugas
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>

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-2014 The PostgreSQL Global Development Group