try to find out the checkpoint record? - Mailing list pgsql-hackers

From Tatsuo Ishii
Subject try to find out the checkpoint record?
Date
Msg-id 20040314.143816.104027800.t-ishii@sra.co.jp
Whole thread Raw
Responses Re: try to find out the checkpoint record?  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [pgsql-hackers-win32] What's left?
Next
From: jseymour@LinxNet.com (Jim Seymour)
Date:
Subject: Re: 7.4.2 Build broken on (Sparc) Solaris 7 and 8