X-Original-To: pgsql-hackers@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 404E04759BD for ; Tue, 18 Feb 2003 14:09:35 -0500 (EST) Received: from candle.pha.pa.us (momjian.navpoint.com [207.106.42.251]) by postgresql.org (Postfix) with ESMTP id F1978475957 for ; Tue, 18 Feb 2003 14:09:33 -0500 (EST) Received: (from pgman@localhost) by candle.pha.pa.us (8.11.6/8.10.1) id h1IJ8Ge19074; Tue, 18 Feb 2003 14:08:16 -0500 (EST) From: Bruce Momjian Message-Id: <200302181908.h1IJ8Ge19074@candle.pha.pa.us> Subject: Re: WAL replay logic (was Re: [PERFORM] Mount options for In-Reply-To: To: Curt Sampson Date: Tue, 18 Feb 2003 14:08:16 -0500 (EST) Cc: pgsql-hackers@postgresql.org X-Mailer: ELM [version 2.4ME+ PL99 (25)] MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=US-ASCII X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200302/989 X-Sequence-Number: 35930 Uh, not sure. Does it guard against corrupt WAL records? --------------------------------------------------------------------------- Curt Sampson wrote: > On Tue, 18 Feb 2003, Bruce Momjian wrote: > > > > > Added to TODO: > > > > * Allow WAL information to recover corrupted pg_controldata > >... > > > Using pg_control to get the checkpoint position speeds up the > > > recovery process, but to handle possible corruption of pg_control, > > > we should actually implement the reading of existing log segments > > > in reverse order -- newest to oldest -- in order to find the last > > > checkpoint. This has not been implemented, yet. > > So if you do this, do you still need to store that information in > pg_control at all? > > cjs > -- > Curt Sampson +81 90 7737 2974 http://www.netbsd.org > Don't you know, in this new Dark Age, we're all light. --XTC > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/users-lounge/docs/faq.html > -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073