Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

I was installing some software completely unrelated to Postgres. The server locked up and I had to do a hard reset. After the server came back up the Postgres service will not start. Has anyone run into this? I have no idea where to even start to troubleshoot it. The postgres service was definately running prior to the lock up.

share|improve this question

migrated from stackoverflow.com Oct 13 '10 at 23:38

This question came from our site for professional and enthusiast programmers.

2 Answers 2

Can you give some more info - which version of Postgres? which binary did you install? I have been running 8.4 on server 2003 with an uptime of over year.. Sounds like the lock up messed with postgres process and corrupted one of its files - I would:

  1. Install postgres to a new location and try load up your tables from there.
  2. Try a File System Level restore: http://www.postgresql.org/docs/8.4/interactive/backup-file.html
  3. Install postgres to the same location hopefully replacing the corrupted file. (backup your old install and tables first!)

Have you tried just starting up postgres once you are on again? Maybe just the autostart is not working.. This question may get better answers on SeverFault..

share|improve this answer

Check the event logs, PostgreSQL startup errors should be there. If that doesn't yield anything, your postgresql.conf specifies where it keeps the other log files, log_directory and log_destination is what you're looking for.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.