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

Re: 60 Seconds to connected to Postgresql using ODBC or PGAdmin

From: "Adam M" <gnuman1(at)gmail(dot)com>
To:
Cc: "Postgresql ODBC List" <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: 60 Seconds to connected to Postgresql using ODBC or PGAdmin
Date: 2007-11-29 07:08:49
Message-ID: 84b37b360711282308w43479ac4h589b1a68217c628e@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-odbc
On Nov 29, 2007 12:51 AM, Richard Broersma Jr <rabroersma(at)yahoo(dot)com> wrote:
> --- On Wed, 11/28/07, Finn Lassen <dcio(at)AxiomInt(dot)com> wrote:
>
> Can anyone else comment on what problems could be causing these slow connections problems?
>
>
> > Meanwhile, I don't understand why it now takes exactly
> > 60 seconds to connect to the database whether I use pgAdmin or my
> > connection string from within VB.
>
> This is very odd.  Since you are having a problem with your connection time on both pgAdmin(which doesn't use ODBC to connect) and ODBC connects, I would assume that you must be having an issue that is non-odbc related.

60 seconds lag that happens all the time is generally a DNS issue.
Whenever a connection takes that long of a time, and the server is not
loaded like crazy, then it is most likely a reverse DNS issue.
Sometimes a forward DNS issue. The delay is just the amount of time
for the DNS lookup to timeout.

- Adam

In response to

Responses

pgsql-odbc by date

Next:From: Richard Broersma JrDate: 2007-11-29 07:13:02
Subject: Re: 60 Seconds to connected to Postgresql using ODBC or PGAdmin
Previous:From: Richard Broersma JrDate: 2007-11-29 06:51:16
Subject: 60 Seconds to connected to Postgresql using ODBC or PGAdmin

pgsql-general by date

Next:From: Richard Broersma JrDate: 2007-11-29 07:13:02
Subject: Re: 60 Seconds to connected to Postgresql using ODBC or PGAdmin
Previous:From: Richard Broersma JrDate: 2007-11-29 06:51:16
Subject: 60 Seconds to connected to Postgresql using ODBC or PGAdmin

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