When trying to upgrade Foglight to 5.7.5.2 the PostgreSQL database failed to upgrade.
The following errors can be found in the log files.
postgresql-<timestamp>.log:
2015-09-04 10:29:28.306 CAT: LOG: database system was shut down at 2015-09-04 10:26:36 CAT
2015-09-04 10:29:28.306 CAT: PANIC: could not open transaction log file "pg_xlog/000000010000000400000050": Permission denied
2015-09-04 10:29:28.462 CAT: LOG: startup process (PID 4508) was terminated by exception 0xC0000409
2015-09-04 10:29:28.462 CAT: HINT: See C include file "ntstatus.h" for a description of the hexadecimal value.
2015-09-04 10:29:28.462 CAT: LOG: aborting startup due to startup process failure
DatabaseUpgrade_<timestamp>.log
2015-09-04 10:20:05.000 ERROR [main] com.quest.nitro.db.EmbeddedDatabaseManager - Failed to exec embedded database process
java.lang.IllegalStateException: Exception while waiting for postgres to get ready for external connections: java.io.IOException: pg_ctl existed with error code 1
at com.quest.nitro.db.PostgreSQLEmbeddedDatabaseHandler.startDatabaseServer(PostgreSQLEmbeddedDatabaseHandler.java:155)
at com.quest.nitro.db.EmbeddedDatabaseManager.startup(EmbeddedDatabaseManager.java:179)
at com.quest.nitro.upgrade.db.DatabaseUpgradeLauncher.processCommandLine(DatabaseUpgradeLauncher.java:212)
at com.quest.nitro.upgrade.db.DatabaseUpgradeLauncher.main(DatabaseUpgradeLauncher.java:109)
Caused by: java.io.IOException: pg_ctl existed with error code 1
at com.quest.nitro.db.PostgreSQLEmbeddedDatabaseHandler.startDatabaseServer(PostgreSQLEmbeddedDatabaseHandler.java:142)
... 3 more
ManagementServer_<timestamp>.log
pg_ctl: PID file "C:/path/to/Foglight installation/state/postgresql-data/postmaster.pid" does not exist