X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 1AE409FB40B for ; Thu, 31 Aug 2006 14:37:36 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 03577-03-8 for ; Thu, 31 Aug 2006 17:37:32 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from bay0-omc2-s37.bay0.hotmail.com (bay0-omc2-s37.bay0.hotmail.com [65.54.246.173]) by postgresql.org (Postfix) with ESMTP id E51FC9FB40F for ; Thu, 31 Aug 2006 14:36:22 -0300 (ADT) Received: from hotmail.com ([64.4.38.47]) by bay0-omc2-s37.bay0.hotmail.com with Microsoft SMTPSVC(6.0.3790.1830); Thu, 31 Aug 2006 10:36:21 -0700 Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Thu, 31 Aug 2006 10:36:21 -0700 Message-ID: Received: from 64.4.38.200 by by116fd.bay116.hotmail.msn.com with HTTP; Thu, 31 Aug 2006 17:36:16 GMT X-Originating-IP: [66.160.12.215] X-Originating-Email: [bitsandbytes88@hotmail.com] X-Sender: bitsandbytes88@hotmail.com From: "Mr. Dan" To: pgsql-admin@postgresql.org Subject: PITR Date: Thu, 31 Aug 2006 13:36:16 -0400 Mime-Version: 1.0 Content-Type: text/plain; format=flowed X-OriginalArrivalTime: 31 Aug 2006 17:36:21.0497 (UTC) FILETIME=[F931AE90:01C6CD23] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.907 tagged_above=0 required=5 tests=DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST, MSGID_FROM_MTA_HEADER, SPF_PASS X-Spam-Level: * X-Archive-Number: 200608/355 X-Sequence-Number: 22898 Hi, Every day I'm arguing with 3 or 4 people on this point. My point is that I have to do a tarball, a tar command as part of online backup with postgresql v814. I keep saying that the reason we do a tarbal (online backup) and not individual dumps is that we want the PITR capability. I've been fighting so many people on this point I want to double check with the group that. 1. There is no way to do a PITR recovery from a dump file at one time during the day. 2. There is no way to do a PITR from SLONY1. Does everyone agree with me on those points? Thanks, ~DjK