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

connection dropping

From: bill <billmac333(at)comcast(dot)net>
To: pgadmin-support(at)postgresql(dot)org
Subject: connection dropping
Date: 2003-10-16 16:04:38
Message-ID: 3F8EC196.3030703@comcast.net (view raw or flat)
Thread:
Lists: pgadmin-support
Hello,
I love pgAdmin III. I use it when working at home. I'm stuck with II at 
work since my machine is W98, although it (II)has a feature I prefer 
over III. Anyway, here on the homefront, I'm connected via high-speed 
cable connection (1.5 meg). I get excellent performance, however, I find 
that pgAdmin drops the DB connection rather quickly if there is no 
activity. If I leave the interface for any amount of time, when I come 
back and click on anything, I get the error message:
"An error has occurred:

server closed the connection unexpectedly
    This probably means the server terminated abnormally before of while 
processing the request."

After this I usually have to click through many dialog boxes telling me 
that there is no connection to the server.

If I look at the process list in the DB server, I can see all the 
connections I have made over a period just sitting there 'idle'.
There is nothing in the log that corresponds with the drop that I can 
tell except with the possibility of:
LOG:  pq_recvbuf: recv() failed: Connection reset by peer
,but these may be from other clients.

What can I do to maintain the connection even if its idle?
Thanks,
Bill


Responses

pgadmin-support by date

Next:From: fmonkeyDate: 2003-10-16 16:31:22
Subject: Re: connection dropping
Previous:From: Rainer ZemanDate: 2003-10-15 20:32:27
Subject: Error Message: Ung├╝ltiger Prozeduraufruf oder ung├╝ltig?==?iso-8859-1?Q?es Argument

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