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

Re: Pgadmin III loses connection with remote database and then hangs for a long time.

From: "Bob McConnell" <rvm(at)CBORD(dot)com>
To: "Guillaume Lelarge" <guillaume(at)lelarge(dot)info>,"Tim Uckun" <timuckun(at)gmail(dot)com>
Cc: <pgadmin-support(at)postgresql(dot)org>
Subject: Re: Pgadmin III loses connection with remote database and then hangs for a long time.
Date: 2011-05-31 13:28:07
Message-ID: FF8482A96323694490C194BABEAC24A0075EBED3@Email.cbord.com (view raw or flat)
Thread:
Lists: pgadmin-support
From: Guillaume Lelarge

> On 05/26/2011 09:45 AM, Tim Uckun wrote:
>> I am using pgAdmin 1.12.1 oct 21 2010 rev-REL-1_12_1 from Martin
>> Pitt's PPA on ubuntu maverick.
>> 
>> Often when I connect to remote database the program seems to lose
>> connection to the database and when this happens it just locks up
>> tight with a blank screen. It stays locked up for a pretty long time
>> and then finally comes back with an error message saying it lost
>> connection. It makes no effort to retry the connection and I usually
>> quit it or kill it at that point.
>> 
>> Normally when it hangs up like that I fire off another instance and
>> reconnect to the same database to finish what I was doing.
>> 
>> The databases I am connecting to are either not fire walled or have a
>> port open for traffic coming from my workstation.
> 
> And no switch between them? Usually, this kind of issues happens
because
> of a faulty firewall or switch.

I have seen similar problems on routers and switches that were
overloaded or misconfigured. Adding memory, or just increasing the
number of buffers available might fix the problem.

Bob McConnell

In response to

Responses

pgadmin-support by date

Next:From: Dave PageDate: 2011-05-31 16:44:23
Subject: Re: pgadmin installation on Windows XP without administrator rights
Previous:From: Guillaume LelargeDate: 2011-05-31 08:37:38
Subject: Re: COMMENT on a wrong object

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