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

From: Richard Huxton <dev(at)archonet(dot)com>
To: Richard Broersma Jr <rabroersma(at)yahoo(dot)com>
Cc: Finn Lassen <dcio(at)AxiomInt(dot)com>, General PostgreSQL List <pgsql-general(at)postgresql(dot)org>
Subject: Re: 60 Seconds to connected to Postgresql using ODBC or PGAdmin
Date: 2007-11-29 08:07:46
Message-ID: 474E7352.60004@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-odbc

Richard Broersma Jr wrote:
> --- On Wed, 11/28/07, Richard Huxton <dev(at)archonet(dot)com> wrote:
>> Name lookups. Something is trying to look up a name, failing and
>> it's timing out after 60 seconds.
>
> It seems the OP's connection string was set to localhost. Would this
> still indicate a Name Loopup problem?

That would make it unlikely.

The only other option that occurs to me would be some firewall type of
package that's taking a long time to allow a connection. It would be an
odd bit of security software that timed out and then *allowed* the
connection to proceed.

Hmm - it looks like the wireshark network sniffer is available for
Windows (http://www.wireshark.org/) - I'd be tempted to install that and
connect to an external IP and see what packets go where. That will save
a lot of head-scratching.

--
Richard Huxton
Archonet Ltd

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Gregory Williamson 2007-11-29 08:23:10 Re: Why upgrade?
Previous Message Peter 2007-11-29 07:57:17 Re: 60 Seconds to connected to Postgresql using ODBC or PGAdmin

Browse pgsql-odbc by date

  From Date Subject
Next Message Shane Ambler 2007-11-29 08:23:15 Re: 60 Seconds to connected to Postgresql using ODBC or PGAdmin
Previous Message Peter 2007-11-29 07:57:17 Re: 60 Seconds to connected to Postgresql using ODBC or PGAdmin