X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 0253C9FB1D2 for ; Thu, 13 Jul 2006 12:16:50 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 08676-02 for ; Thu, 13 Jul 2006 12:16:42 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from web52012.mail.yahoo.com (web52012.mail.yahoo.com [206.190.48.95]) by postgresql.org (Postfix) with SMTP id 98F369FB1D8 for ; Thu, 13 Jul 2006 12:16:41 -0300 (ADT) Received: (qmail 55610 invoked by uid 60001); 13 Jul 2006 15:16:36 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=JmLtK9Z4ZrYbX4lTQlrqeP25Z8N15W2Xfu7LxSowflIeR4yMW2Rzr4dqXOZOrLmn/tF4Ff0JgWMTTstSBQZOoJWy9+UISsOeRglLmrvlCWKkDzkwbOKJ7KBz05q4uEOtlwpnwYGu46pxuRq6qhrGuUwofkw5pvl9yzq4YPiLslA= ; Message-ID: <20060713151636.55608.qmail@web52012.mail.yahoo.com> Received: from [203.126.136.220] by web52012.mail.yahoo.com via HTTP; Thu, 13 Jul 2006 08:16:36 PDT Date: Thu, 13 Jul 2006 08:16:36 -0700 (PDT) From: Satya Prakash Tripathi Subject: PITR- timeline query To: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200607/97 X-Sequence-Number: 22343 Hi , I am experimenting with PITR aspect of postgres8.0, and I needed some answers on this subject. I have following questions : 1) At time t0, I created a base backup. (got a backup marker file named as: 0000000800000002000000A8.005E61B4.backup) (assume no previous base backups and recoveries...) On time t2 I did a recovery till time t1 ( t0