Qlik Sense Repository Database starts and stops: "FATAL: lock file "postmaster.pid" already exists"
Article Number: 000047195 | Last Modified: 2018/11/21
The Qlik Sense Repository Database service starts and stops immediately.
The Windows Events Application logs show errors like this: "FATAL: lock file "postmaster.pid" already exists HINT: Is another postmaster (PID XXXX) running in data directory "C:\ProgramData\Qlik\Sense\Repository\PostgreSQL\9.x"
Qlik Sense 3.x or above
The service previously hung while stopping.
- stop all Qlik Sense services
- delete the postmaster.pid file contained in C:\ProgramData\Qlik\Sense\Repository\PostgreSQL\9.6 (9.3 for Qlik Sense 3)
- in an elevated prompt, run
Taskkill /PID XXXX /F
(replace XXXX with the PID from the Windows Event logs error)
- start the Qlik Sense Services in the correct order
As an alternative, fully rebooting the server will also solve the issue.