I am testing postgres for HA and at one stage I could not start the
db. I get the following message:
LOG: database system was shut down at 2007-02-22 16:07:51 PST
LOG: could not open file "pg_xlog/00000001000000000000000B" (log file
0, segment 11): No such file or directory
LOG: invalid primary checkpoint record
LOG: could not open file "pg_xlog/00000001000000000000000B" (log file
0, segment 11): No such file or directory
LOG: invalid secondary checkpoint record
PANIC: could not locate a valid checkpoint record
LOG: startup process (PID 21951) was terminated by signal 6
LOG: aborting startup due to startup process failure
LOG: logger shutting down
I think files from pg_xlog got removed. I am trying to start the db,
but fails with the above message. How do I recover and come to a point
where I can start the database? I do have the schema dump avl. so once
it is started, I can restore it back. I just need it to start to a
point where I can connect to it and possibly create/drop db.
Thanks in advance!
Dhaval Shah