[QGIS-trac] [Quantum GIS] #1810: PostGIS connections keepalive

[Quantum GIS]

#1810: PostGIS connections keepalive
--------------------------------------------+-------------------------------
   Reporter:  bonzai                        |              Owner:  nobody       
       Type:  enhancement                   |             Status:  new          
   Priority:  minor: annoyance              |          Milestone:  Version 1.2.0
  Component:  Data Provider                 |            Version:  HEAD         
   Keywords:  postgis connection keepalive  |   Platform_version:               
   Platform:  All                           |           Must_fix:  No           
Status_info:  0                             |  
--------------------------------------------+-------------------------------
 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.

-- 
Ticket URL: <https://trac.osgeo.org/qgis/ticket/1810>
Quantum GIS <http://qgis.org>
Quantum GIS is an Open Source GIS viewer/editor supporting OGR, PostGIS, and GRASS formats