Feature request #1810

PostGIS connections keepalive

Added by bonzai - about 11 years ago. Updated almost 9 years ago.

Status:Closed
Priority:Low
Assignee:Jürgen Fischer
Category:Data Provider
Pull Request or Patch supplied:No Resolution:fixed
Easy fix?:No Copied to github as #:11870

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.

History

#1 Updated by Jürgen Fischer almost 9 years ago

  • Pull Request or Patch supplied set to No
  • Resolution set to fixed
  • Status changed from Open to Closed

qgis now reconnects in case of failure (see b86243ed9f6be9766284bc2e8ea82e7d4c0fbb5e)

Also available in: Atom PDF