[mapserver-users] PostGIS raster connection is not closed by MapServer

[Martin Hoegh]

I'm using PostGIS raster in MapServer like this:

TYPE RASTER
DATA “PG:port=5432 dbname='mydb' user='postgres' password='1234' schema='public' table='truemarble' mode='2'"
PROCESSING "CLOSE_CONNECTION=ALWAYS"

My problem is that the database connection is not closed after a request, which leads to connection leak. It works fine with PostGIS vectors in the same database.

Any ideas?

I've tested with:
python_mapscript in a mod_python application
php_mapscript in a php-fpm application (Fastcgi)
Both on apache2-mpm-worker

MapServer 6.2 and 6.4, GDAL 1.10 and GDAL 1.11, Ubuntu 12.04 and 14.04

For now I’ve fixed it with pgbouncer.

Martin Høgh

mapcentia.com
+45 26277810
Skype: mhoegh1
about.me/mhoegh