How to Keep the PostgreSQL Windows Service Running 24/7 with Service Protector

PostgreSQL is popular open-source object-relational database system. It installs itself as a Windows Service, to start automatically before anyone logs on to the server:

To protect the PostgreSQL Windows Service with Service Protector:

1. Download and install Service Protector, if necessary.

2. Start Service Protector.

3. Select Protector > Add to open the Add Protector window:

   

4. On the General tab, in the Service to protect field, choose the PostgreSQL service. The name will be in the format:

   postgresql-x64-[VERSION-NUMBER]

   For example, since we installed version 18, the service is called "postgresql-x64-18" on our machine:

   

5. The basic setup is complete so click the Save button to record your settings. In a couple of seconds, an entry for PostgreSQL will show up in the Service Protector window.

   At this point, PostgreSQL is already being monitored by Service Protector:

   

6. That's it! Next time your computer boots, PostgreSQL will start and Service Protector will babysit the service to promptly restart it if it fails.

   We encourage you to edit PostgreSQL in Service Protector and check out the many other settings that may be appropriate for your environment.

   For example, send an email when the service fails, restart PostgreSQL if it runs away with the CPU, and much more.

Trouble protecting the PostgreSQL Windows Service?

• From Service Protector, select Protector > Report Activity > Today to bring up an HTML report detailing the interaction between Service Protector and PostgreSQL.

• Browse the Service Protector FAQ for answers to commonly asked questions and troubleshooting tips.

• Contact us and we will be happy to help!