I had an OpenNMS test install running with PostgreSQL until some PAT testers decided to pull the plug on it whilst it was running.
Unfortunately I cannot start my OpenNms install. This is because Postgresql will not start.
Doing: "service postgresql start" just brings up a "failed" message
Looking at my postgresql logs, i find the following;
FATAL: lock file "postmaster.pid" already exists
HINT: Is another postmaster PID (2904) running in data directory "/var/lib/pgsql/data"?
FATAL: bogus data in lock file "postmaster.pid": ""
What can i do to resolve this? I have forced an fsck fisk check at boot and rebooted, but the problem still remains.