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 840FAD1B1AA for ; Tue, 13 Jul 2004 20:28:28 -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 23278-06 for ; Tue, 13 Jul 2004 23:28:25 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 05D34D1B198 for ; Tue, 13 Jul 2004 20:28:21 -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 i6DNSLUT020206; Tue, 13 Jul 2004 19:28:22 -0400 (EDT) To: Bruce Momjian Cc: Simon Riggs , pgsql-hackers@postgresql.org Subject: Re: Point in Time Recovery In-reply-to: <200407132301.i6DN1fb16205@candle.pha.pa.us> References: <200407132301.i6DN1fb16205@candle.pha.pa.us> Comments: In-reply-to Bruce Momjian message dated "Tue, 13 Jul 2004 19:01:41 -0400" Date: Tue, 13 Jul 2004 19:28:21 -0400 Message-ID: <20205.1089761301@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/736 X-Sequence-Number: 56297 Bruce Momjian writes: > OK, but procedurally, how do you correlate the start/stop time of the > tar backup with the WAL numeric file names? Ideally the procedure for making a backup would go something like: 1. Inquire of the server its current time and the WAL position of the most recent checkpoint record (which is what you really need). 2. Make the backup. 3. Inquire of the server its current time and the current end-of-WAL position. 4. Record items 1 and 3 along with the backup itself. I think the current theory was you could fake #1 by copying pg_control before everything else, but this doesn't really help for step #3, so it would probably be better to add some server functions to get this info. regards, tom lane