Ticket #1810 (new enhancement)
PostGIS connections keepalive
|Reported by:||bonzai||Owned by:||jef|
|Priority:||minor: annoyance||Milestone:||Version 1.7.0|
|Keywords:||postgis connection keepalive||Cc:|
|Must Fix for Release:||No||Awaiting user input:||no|
I've experienced frequent PostGIS layers' connections breaking using ADSL connection. After a brief inactivity (about 5 minutes) any connection attempts fail returning empty tables. Server side Postgres tcp_keepalive parameters are setted to default and pg_stat_activity states postgis connections as idling. So seems that server keepalive packets can't reach clients through ADSL.
In order to resolve this problem maybe should be useful add some client side keepalive routine.