AnsweredAssumed Answered

How to recover Crashed postgres database?

Question asked by chrisryder on Sep 8, 2015
Latest reply on Sep 9, 2015 by mrogers
Please Help

I am on Centos 6.6 using the default configuration for alfresco community 4.2f.  Due to a power outage the server restarted.  Alfresco cannot restart as I get.
waiting for server to start…….. stopped waiting
pg_ctl.bin: could not start server
Examine the log output.

There is NO log.  I have checked catalina.out which states that postgres is not running
I have checked the /var logs and cannot find anything related to postgres.

I have checked the forums here but find absolutely no relevant posts.

I still have a huge content store (less than 7% disk space usage). 
1. Can I get alfresco to rebuild the postgres database without losing all the input? (if so how?)
or
2. Can I recover the postgres database?  (if so how?)

A backup would not help here as the last backup is too old (older than one day).

I can stand losing one or two files but reverting to the backup would lose more than 4000 :(

I was about to start migrating to the latest version 5 and this happens.  If I cannot recover alfresco will be replaced with Micro$oft which would be a big shame as I have invested a great deal of time in this.

Outcomes