artemp/trac2github — Issue #500: Graceful recovery if postgres connection is lost
Author: artemp
Created: 2011-10-09 20:37:29+00:00
State: open
Labels: PostGIS_Input_Driver

Could be useful: ability to recover without exception if a database connection is lost abruptly.

{{{
RuntimeError: PSQL error: server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request. Full sql was: 'SELECT AsBinary("way",'NDR') AS ...
}}}

To recreate:
* Run mapnik as a process within Apache
* Restart postgres abruptly
* Mapnik process inside apache hits exception after loosing connection, even after postgres is running again.

The priority behavior should be to maintain the ability to open new connections to a running postgres database server, but this above edge case would also be good to look into.