Conn. loose at some places | TCP keepalive

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

Conn. loose at some places | TCP keepalive

durumdara
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


Reply | Threaded
Open this post in threaded view
|

Re: Conn. loose at some places | TCP keepalive

Murtuza Zabuawala
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,
Murtuza Zabuawala
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


On Tue, Feb 13, 2018 at 1:26 PM, Durumdara <[hidden email]> 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



Reply | Threaded
Open this post in threaded view
|

Re: Conn. loose at some places | TCP keepalive

durumdara
Hello!

2018-02-13 12:48 GMT+01:00 Murtuza Zabuawala <[hidden email]>:
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,
Murtuza Zabuawala
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company




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
 
Reply | Threaded
Open this post in threaded view
|

Re: Conn. loose at some places | TCP keepalive

Murtuza Zabuawala
On Tue, Feb 13, 2018 at 7:17 PM, Durumdara <[hidden email]> wrote:
Hello!

2018-02-13 12:48 GMT+01:00 Murtuza Zabuawala <[hidden email]>:
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,
Murtuza Zabuawala
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company




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


Thanks
  dd
 

Previous Thread Next Thread