Re: Establishing remote connections is slow

Hi,

if you try to connect with pssql over your IP and it works slow, it is
possible that you have problem with reverse dns lookup. To check, try to
run nslookup tool, and enter your IP address (on the same machine) - if
it is problem with dns, it will resolve it slow as well..
Also, try to check traceroute/trapath utilities with the same IP maybe it
will show you something strange..

Lukas

> On Tue, Jan 17, 2012 at 3:41 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>
>> Hm.  AFAIR postgres doesn't know anything particular about multipath
>> interfaces --- it just listens where you tell it to.
>
> I was thinking the same, but PostgreSQL is the "first line to contact"
> and I somehow need to obtain a proof that this is indeed a
> system-level issue. My simple netcat experiments seem to suggest the
> opposite.
>
>>  So I'm thinking this is a system-level issue.  It still seems like it
>> could be DNS
>> lookup related though.  Do you have log_hostname turned on, and if so
>> does turning it off make a difference?
>
> log_hostname is turned off.
>
> Thanks for your help!
>
> 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
>