Forum OpenACS Q&A: Re: Better handling of PostgreSQL shutdown/startup

Collapse
Posted by Lamar Owen on
There are two distinct situations here.

One is where an individual backend dies -- this is properly reconnected.

Two is when the postmaster dies -- this is not currently reconnected.  I am looking at ways of doing this, but it is going to take some time to properly troubleshoot.

In the interim, ask Marc (or whoever your contact is) at hub to coordinate shutdown of AOLserver with postmaster restart -- they're probably rolling their logs.  Simply shutdown AOLserver first, then restart postmaster, then restart AOLserver.  You do wind up with 30 seconds to a minute of downtime as OpenACS reloads.

This is one of my biggest TODO items for the post-3.5 release of the nspostgres driver.