Ticket #1810 (new enhancement)

Opened 4 years ago

Last modified 3 years ago

PostGIS connections keepalive

Reported by: bonzai Owned by: jef
Priority: minor: annoyance Milestone: Version 1.7.0
Component: Data Provider Version: Trunk
Keywords: postgis connection keepalive Cc:
Platform Version: Platform: All
Must Fix for Release: No Awaiting user input: no

Description

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.

Change History

Changed 4 years ago by lutra

  • owner changed from nobody to jef

Changed 3 years ago by pcav

  • milestone changed from Version 1.5.0 to Version 1.6.0
Note: See TracTickets for help on using tickets.