Although most of the administrative tasks for the PostgreSQL Server are done through the PostgreSQL tools, starting and stopping of the PostgreSQL Server should not be one of them:
- Consistent state – When SIOS Protection Suite stops and starts the PostgreSQL Server, 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 Server.
- 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.