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

Re: Very Slow connecting and loading database

From: Jean-Michel POURE <jm(dot)poure(at)freesurf(dot)fr>
To: "Roberto Mason" <systemtech(at)robertomason(dot)pointclark(dot)net>,"Pgadmin-Support (E-mail)" <pgadmin-support(at)postgresql(dot)org>
Subject: Re: Very Slow connecting and loading database
Date: 2003-02-16 08:09:45
Message-ID: 200302160909.45750.jm.poure@freesurf.fr (view raw or flat)
Thread:
Lists: pgadmin-support
Le Vendredi 14 Février 2003 18:49, Roberto Mason a écrit :
> When I connect with pgadminII to the server  (log in with postgres -
> no password), it takes up to 3-4 minutes to connect. When I click to the
> database "bobsimple - sample database", it can take over 5 minutes to
> "examine".

I already had a similar problem. It is not a PostgreSQL problem.

Looks like Linux is convigured with DNS reverse lookup (for security reasons), 
and hence will try to convert any IP connection into a DNS name. Two possible 
solutions:
- disable reverse DNS lookup,
- add your Windows client address to the list of known host.

Cheers,
Jean-Michel POURE

In response to

pgadmin-support by date

Next:From: Dave PageDate: 2003-02-16 20:51:06
Subject: Re: pgadmin2-1_4_12 CURSOR PROBLEM. IT RETURNS 'Query executed Ok'!!!Why??
Previous:From: Devang JadavDate: 2003-02-15 20:11:42
Subject: pgadmin2-1_4_12 CURSOR PROBLEM. IT RETURNS 'Query executed Ok'!!!Why??

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