Re: Slow connection once the PC is network connected - Mailing list pgsql-general

From Alban Hertroys
Subject Re: Slow connection once the PC is network connected
Date
Msg-id A71C2D25-8C1D-4811-A6D8-1785D5C4295A@solfertje.student.utwente.nl
Whole thread Raw
In response to Slow connection once the PC is network connected  (Yan Cheng CHEOK <yccheok@yahoo.com>)
Responses Re: Slow connection once the PC is network connected
List pgsql-general
On 26 Oct 2010, at 11:39, Yan Cheng CHEOK wrote:

> Hello, I am deploying a database to customer PC, which will be only connected by local application.
>
> However, I realize once the PC is network connected, the connection take extremely long time (around 10 seconds)

That sounds suspiciously like the default timeout for DNS lookups.
What platform is this? Windows?
Is that machine able to look up localhost?

> May I know why this happen? I was wondering whether is there any workaround to overcome this?
>
> I connect the database using C++ code
>
> PQconnectdb("dbname = ProductionFactory user = postgres password = password");


Does it help any to add hostaddr = 127.0.0.1 to that string?

Alban Hertroys

--
Screwing up is an excellent way to attach something to the ceiling.


!DSPAM:737,4cc6a70710292409920920!



pgsql-general by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: Slow connection once the PC is network connected
Next
From: Merlin Moncure
Date:
Subject: Re: rule which unpredictable modify a sequence number