Re: 60 Seconds to connected to Postgresql using ODBC or PGAdmin - Mailing list pgsql-general

From Usama Dar
Subject Re: 60 Seconds to connected to Postgresql using ODBC or PGAdmin
Date
Msg-id ff0e67090711290434k15dd3a88qd969945600faa3ed@mail.gmail.com
Whole thread Raw
In response to Re: 60 Seconds to connected to Postgresql using ODBC or PGAdmin  (Shane Ambler <pgsql@Sheeky.Biz>)
List pgsql-general
Or you can try using a simple packet sniffer, maybe ,ethereal , to see if name resolution is going on, i had similar problems with MySQL name resolution in the past and they generally went away after disabling its name resolution and just use IPs

On Nov 29, 2007 1:23 PM, Shane Ambler <pgsql@sheeky.biz> wrote:
Richard Broersma Jr wrote:
> --- On Wed, 11/28/07, Richard Huxton <dev@archonet.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?
>

If there is no entry (or an incorrect one) in /etc/hosts for localhost -
then yes - try to connect to 127.0.0.1 and see if that makes a difference.

Also if it is set to do namelookup before referring to /etc/hosts it can
have similar probs.


--

Shane Ambler
pgSQL@Sheeky.Biz

Get Sheeky @ http://Sheeky.Biz

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to majordomo@postgresql.org so that your
      message can get through to the mailing list cleanly

pgsql-general by date:

Previous
From: Martin
Date:
Subject: Porting from FrontBase
Next
From: Jennifer Spencer
Date:
Subject: Postgres WarmStandby using ZFS or Snapshot to create Web DB?