How to recover Crashed postgres database?

[chrisryder]

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.

[eswbitto]

I'm not sure if this will work or not, but you could give it a try.

Install Alfresco on the same server (again) but give it a different service name than your original install.

Then point the new install to the other alf_data folder and see if it truly is an issue with your data/database or if something happened with your original install files.

You should invest in an UPS system

[mrogers]

Try to find out whether postgress is reporting startup errors.   It's likely it is.    But they won't be in catialina.out or alfresco.log.

Also look on the postgress forums as and when you find what is wrong.

http://www.postgresql.org/docs/8.3/static/server-start.html