Обсуждение: Pgadmin bug.

Поиск
Список
Период
Сортировка

Pgadmin bug.

От
Александр Ющенко
Дата:
<div class="WordSection1"><p class="MsoNormal"><span lang="EN-US">Hello!</span><p class="MsoNormal"><span
lang="EN-US">Ourteam use pgAdmin and notice one:</span><p class="MsoNormal"><span lang="EN-US">if we don’t use pgAdmin
forsome time(5-20 mins), it closing all connections with all databases.</span><p class="MsoNormal"><span
lang="EN-US">Weare using  Windows 7 and lastest version of PgAdmin. </span><p class="MsoNormal"><span
lang="EN-US">Language:Russian; distribution: binary.</span><p class="MsoNormal"><span lang="EN-US"> </span><p
class="MsoNormal"><b><spanlang="EN-US" style="mso-fareast-language:RU">Best Regards, </span></b><p
class="MsoNormal"><b><spanlang="EN-US" style="mso-fareast-language:RU">Yushchenko Aleksandr,</span></b><p
class="MsoNormal"><b><spanlang="EN-US" style="mso-fareast-language:RU">PHP developer</span></b><span lang="EN-US"
style="mso-fareast-language:RU"></span><pclass="MsoNormal"><span lang="EN-US"
style="font-size:9.0pt;mso-fareast-language:RU"> </span><pclass="MsoNormal"><a href="http://www.svoy.ru"><span
lang="EN-US"style="color:windowtext;mso-fareast-language:RU">www.svoy.ru</span></a><span lang="EN-US"
style="mso-fareast-language:RU"></span><pclass="MsoNormal"><span style="mso-fareast-language:RU">+7 9</span><span
lang="EN-US"style="mso-fareast-language:RU">26 895 43 02</span><p class="MsoNormal"><span lang="EN-US"
style="mso-fareast-language:RU">skype</span><spanstyle="mso-fareast-language:RU">: </span><span lang="EN-US"
style="mso-fareast-language:RU">sahkalit</span><spanlang="EN-US"
style="font-size:9.0pt;mso-fareast-language:RU"></span><pclass="MsoNormal"> </div> 

Re: Pgadmin bug.

От
Guillaume Lelarge
Дата:
On Thu, 2012-09-20 at 13:02 +0400, Александр Ющенко wrote:
> Hello!
>
> Our team use pgAdmin and notice one:
>
> if we don't use pgAdmin for some time(5-20 mins), it closing all connections
> with all databases.
>

It doesn't close connections by itself. Connections might get killed by
a firewall or any other network equipment. You should check these, or
try the keepalives parameters of PostgreSQL.


--
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com




Re: Pgadmin bug.

От
Александр Ющенко
Дата:
Ok, but after that reconnect takes a long of time. And often does not work at all.


Best Regards,
Yushchenko Aleksandr,
PHP developer

www.svoy.ru
+7 926 895 43 02
skype: sahkalit

-----Original Message-----
From: Guillaume Lelarge [mailto:guillaume@lelarge.info]
Sent: Friday, September 21, 2012 12:54 AM
To: Александр Ющенко
Cc: pgadmin-support@postgresql.org
Subject: Re: [pgadmin-support] Pgadmin bug.

On Thu, 2012-09-20 at 13:02 +0400, Александр Ющенко wrote:
> Hello!
>
> Our team use pgAdmin and notice one:
>
> if we don't use pgAdmin for some time(5-20 mins), it closing all
> connections with all databases.
>

It doesn't close connections by itself. Connections might get killed by a firewall or any other network equipment. You
shouldcheck these, or try the keepalives parameters of PostgreSQL. 


--
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com