Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Richard Broersma Jr wrote:
--- On Wed, 11/28/07, Finn Lassen <dcio@xxxxxxxxxxxx> 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.

Name lookups. Something is trying to look up a name, failing and it's timing out after 60 seconds.

Could be DNS, or WINS (or whatever MS' current name resolution system is called). It could be either end of the connection too, if for example something on the server is logging the names of connecting clients.

Try a couple of name lookups (forward and reverse) from each end and see what happens.

--
  Richard Huxton
  Archonet Ltd

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

              http://www.postgresql.org/docs/faq

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux