try to find out the checkpoint record?

From: Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp>
To: pgsql-hackers(at)postgresql(dot)org
Subject: try to find out the checkpoint record?
Date: 2004-03-14 05:38:16
Message-ID: 20040314.143816.104027800.t-ishii@sra.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Currently we need to read pg_control to know the location(LSN) of the
checkpoint record. This means if pg_control is lost or corrupted, we
have to give up the database recovery. I think we could start from the
first WAL segment and read through entire WAL logs to find out the
latest valid checkpoint record. This may take considerable amount of
time, but still better than giving up recovery IMO. Any reason we
cannot do this?
--
Tatsuo Ishii

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Jim Seymour 2004-03-14 05:40:53 Re: 7.4.2 Build broken on (Sparc) Solaris 7 and 8
Previous Message Tom Lane 2004-03-14 05:37:03 Re: [pgsql-hackers-win32] What's left?