I have a PostgreSQL server that was restarted. When it was brought back online, PostgreSQL fails to start with:
....LOG: database system was interrupted; last known up at ....
....LOG: unexpected pageaddr 2F/8D000000 in log file 47, segment 159, offset 0
....LOG: invalid primary checkpoint record
....LOG: invalid secondary checkpoint record
....PANIC: could not locate a valid checkpoint record
....LOG: startup process (PID 20879) was terminated by signal 6: Aborted....LOG: aborting startup due to startup process failure
I have pg_dumps that were taken prior to failure that I can restore to if I can get PostgreSQL running again.
How can I fix PostgreSQL? I have seen pg_resetxlog but there are so many warnings, I want to make sure that this is the tool to use.
Thanks.
Laura