Start and Stop PostgreSQL Only Through LifeKeeper

Although most of the administrative tasks for the PostgreSQL are done through the PostgreSQL tools, starting and stopping of the PostgreSQL should not be one of them:

1. Consistent state – When LifeKeeper stops and starts the PostgreSQL, it maintains a consistent state for the protected Microsoft Service. Performing start and stop requests via the command line using the PostgreSQL tools such as pg_ctl.exe creates an inconsistent state for the Microsoft Service, as it is unable to detect the state as running or stopped. This can result in failures to detect and correct issues for the PostgreSQL.

2. Protected PostgreSQL services should be set to Manual startup mode through the Control Panel “Services” tool. Note: When creating a PostgreSQL resource hierarchy the protected service will automatically be set to Manual startup mode.