I've been working with postgres on a linux server for the last couple of months. Last week, half of our servers crashed and my one with them. I was in the middle of uploading data to the postgres database with osm2pgsql when this happened. After we revived the server, postgres has stopped working.
service postgresql start (Alternatively, /etc/rc.d/init.d/postgresql start, same thing happens)
Starting postgresql service: [ OK ]
service postgresql status
postmaster dead but pid file exists
Trying to start the postmaster using
postmaster -D /var/lib/pgsql/data
yields nothing either.
As for the pid file, /var/run/postmaster.5432.pid exists, and when I remove it then the status changes to "postmaster is stopped", but if I try to start it again:
service postgresql start
Starting postgresql service: [FAILED]
If anyone has any idea what I could do to get it working, where the problem might be etc, I would be overjoyed to have an answer. What really gets me is that oit was working until last week, I even rebooted a backup and nothing seems to have changed, I'm really at my wuit's end with this problem!