Thread: Conn. loose at some places | TCP keepalive
Hello!
At home me and some other colleagues loose the connection after 5 minutes.
In other places (office) this not happens.
I wrote about this here:
Yesterday I found a solution-like thing for PGAdmin III here:
In PgAdmin IV I also have this problem.
But here I don't find same "service" option to link to my parameters.
What I can do here? Do you know hidden service option in PGAdmin IV?
The solution is may be an option for "SQL command list after connect" for each servers - with this I could configure TCP keepalive parameters manually.
Thank you for your answer!
dd
I also use pgAdmin4 over vpn many times but I do not face any such issue, I think this is environment specific issue in your case.
--![](https://drive.google.com/a/enterprisedb.com/uc?id=0B6jGeB3BfKRMV0t4MEp0YnZCTTA&export=download)
Regards,
On Tue, Feb 13, 2018 at 1:26 PM, Durumdara <durumdara@gmail.com> wrote:
Hello!At home me and some other colleagues loose the connection after 5 minutes.In other places (office) this not happens.I wrote about this here:Yesterday I found a solution-like thing for PGAdmin III here:In PgAdmin IV I also have this problem.But here I don't find same "service" option to link to my parameters.What I can do here? Do you know hidden service option in PGAdmin IV?The solution is may be an option for "SQL command list after connect" for each servers - with this I could configure TCP keepalive parameters manually.Thank you for your answer!dd
Hello!
2018-02-13 12:48 GMT+01:00 Murtuza Zabuawala <murtuza.zabuawala@enterprisedb.com>:
I also use pgAdmin4 over vpn many times but I do not face any such issue, I think this is environment specific issue in your case.--Regards,
With VPN I also haven't got problem. With SSL + cert + outer server I get it in all inactive 5 minutes... :-(
My three colleauges too, but some other not.
Before I read the link I thought it's impossible to avoid, but PGAdmin III successfully hacked with this technique...
I search for same option in PGAdmin IV, but I don't find now.
All libpq.dll based apps suffered this behaviour - pgsql, EMS SQL Manager, Navicat, PGAdmin III/IV.
If I could define "onconnect" extra parameters or SQL commands somewhere, I can change the TCP keepalive to lower, and the limitations would vanish...
Thanks
dd
Hello!2018-02-13 12:48 GMT+01:00 Murtuza Zabuawala <murtuza.zabuawala@enterprisedb.com>: I also use pgAdmin4 over vpn many times but I do not face any such issue, I think this is environment specific issue in your case.--Regards,With VPN I also haven't got problem. With SSL + cert + outer server I get it in all inactive 5 minutes... :-(My three colleauges too, but some other not.Before I read the link I thought it's impossible to avoid, but PGAdmin III successfully hacked with this technique...I search for same option in PGAdmin IV, but I don't find now.All libpq.dll based apps suffered this behaviour - pgsql, EMS SQL Manager, Navicat, PGAdmin III/IV.If I could define "onconnect" extra parameters or SQL commands somewhere, I can change the TCP keepalive to lower, and the limitations would vanish...
Please create a feature request here
--Murtuza
Thanksdd