Recovering from a corrupt database

From: "Dhaval Shah" <dhaval(dot)shah(dot)m(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Recovering from a corrupt database
Date: 2007-02-27 23:06:25
Message-ID: 565237760702271506g614e0c16ga162479b46a6d9d2@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2007-02-27 23:16:40 Re: How to Kill IDLE users
Previous Message Goran Rakic 2007-02-27 21:23:13 How to Kill IDLE users