connection dropping continued
От | Markus Wollny |
---|---|
Тема | connection dropping continued |
Дата | |
Msg-id | 2266D0630E43BB4290742247C891057502B9D486@dozer.computec.de обсуждение исходный текст |
Ответы |
Re: connection dropping continued
|
Список | pgadmin-support |
Hello! Referring to http://www.mail-archive.com/pgadmin-support@postgresql.org/msg02050.html , I'd like to ask if there's going to be some remedy to the problem any time in the near future? We're using PGAdmin III and it's really an extremely useful admin-tool for PostgeSQL, but this issue is really quite unnerving, though it may not be the apllication's fault at all: > 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. We're behind a firewall on a connection which is routed securely between two internal networks - our servers are sitting in one and we are on the other one. Our admin tells us that there's really no way he would be willing or able to somehow fix this firewall problem; right now, what we'd really like to see would be some option for keeping our connections alive inside PGAdmin III - maybe some additional "Keep-Alive"-settings unter options where one could switch the feature on or off and define the interval for the requests to the database-clusters which are currently active in the servers-tab. Just some "select '1';" to template1 every 30 seconds would be more than sufficient to resolve the problem for us. Any chance for this to be included some time soon? Kind regards and thanks for this excellent piece of software, Markus
В списке pgadmin-support по дате отправления: