X-Original-To: pgsql-hackers-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id A7FF2D1B297 for ; Tue, 13 Jul 2004 11:29:55 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 65910-06 for ; Tue, 13 Jul 2004 14:30:04 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 753B5D1B1D9 for ; Tue, 13 Jul 2004 11:29:54 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.11/8.12.11) with ESMTP id i6DETiRO015781; Tue, 13 Jul 2004 10:29:44 -0400 (EDT) To: Simon Riggs Cc: Alvaro Herrera , Bruce Momjian , mascarm@mascari.com, ZeugswetterA@spardat.at, pgsql-hackers@postgresql.org Subject: Re: Point in Time Recovery In-reply-to: <1089718702.17493.2527.camel@stromboli> References: <1089060299.17493.58.camel@stromboli> <4263.1089064016@sss.pgh.pa.us> <1089150005.17493.270.camel@stromboli> <1089718702.17493.2527.camel@stromboli> Comments: In-reply-to Simon Riggs message dated "Tue, 13 Jul 2004 12:38:23 +0100" Date: Tue, 13 Jul 2004 10:29:44 -0400 Message-ID: <15780.1089728984@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200407/667 X-Sequence-Number: 56228 Simon Riggs writes: > Please tell me that we can ignore the state of the clog, We can. The reason that keeping track of timelines is interesting for xlog is simply to take pity on the poor DBA who needs to distinguish the various archived xlog files he's got laying about, and so that we can detect errors like supplying inconsistent sets of xlog segments during restore. This does not apply to clog because it's not archived. It's no more than a data file. If you think you have trouble recreating clog then you have the same issues recreating data files. regards, tom lane