FME Server Database Service Does Not Start After Reboot

Symptom

1. Reboot a Windows machine and the FME Server web interface doesn't allow you to login.
2. Check Windows services: FME Server Database service is not running.
3. Starting the service manually fails.
4. Check Windows event viewer and see errors like:
   • lock file "postmaster.pid" already exists
   • pg_ctl: this data directory appears to be running a pre-existing postmaster

Cause

The issue is tied to the PostgreSQL database, the underlying database that is used by FME Server.

Resolution

To correct this issue, open the Windows task manager and end all processes/services with the name "postgres".

Restart all FME services using directions listed here: Working with the System Services. The Database service should now start and you should be able to login.