From: | Yan Cheng CHEOK <yccheok(at)yahoo(dot)com> |
---|---|
To: | Alban Hertroys <dalroi(at)solfertje(dot)student(dot)utwente(dot)nl> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Slow connection once the PC is network connected |
Date: | 2010-11-01 02:20:00 |
Message-ID: | 709805.34344.qm@web65709.mail.ac4.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Thanks. That's work pretty well.
--- On Tue, 10/26/10, Alban Hertroys <dalroi(at)solfertje(dot)student(dot)utwente(dot)nl> wrote:
> From: Alban Hertroys <dalroi(at)solfertje(dot)student(dot)utwente(dot)nl>
> Subject: Re: [GENERAL] Slow connection once the PC is network connected
> To: "Yan Cheng CHEOK" <yccheok(at)yahoo(dot)com>
> Cc: pgsql-general(at)postgresql(dot)org
> Date: Tuesday, October 26, 2010, 6:01 PM
> 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!
>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
From | Date | Subject | |
---|---|---|---|
Next Message | Carlos Henrique Reimer | 2010-11-01 08:49:59 | Linux x Windows LOCALE/ENCODING compatibility |
Previous Message | Alban Hertroys | 2010-10-31 23:22:00 | Re: How to determine server version inside select statement |