X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 0907D8BA019 for ; Fri, 4 Feb 2005 06:29:51 +0000 (GMT) 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 69253-07 for ; Fri, 4 Feb 2005 06:29:48 +0000 (GMT) Received: from moutng.kundenserver.de (moutng.kundenserver.de [212.227.126.191]) by svr1.postgresql.org (Postfix) with ESMTP id 28FEF8B9FBE for ; Fri, 4 Feb 2005 06:29:47 +0000 (GMT) Received: from [212.227.126.208] (helo=mrelayng.kundenserver.de) by moutng.kundenserver.de with esmtp (Exim 3.35 #1) id 1CwwyO-0001L0-00; Fri, 04 Feb 2005 07:29:44 +0100 Received: from [192.59.128.130] (helo=stromboli) by mrelayng.kundenserver.de with asmtp (Exim 3.35 #1) id 1CwwyO-0002PX-00; Fri, 04 Feb 2005 07:29:44 +0100 From: "Simon Riggs" To: "Mark Reidenbach" , Subject: Re: PITR WAL backups Date: Thu, 3 Feb 2005 21:29:36 -0800 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2911.0) X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700 In-Reply-To: <42012233.40700@everytruckjob.com> Importance: Normal X-Provags-ID: kundenserver.de abuse@kundenserver.de auth:51320d06ba6b43864a3fe5d428030dbe X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200502/26 X-Sequence-Number: 16194 >Mark Reidenbach wrote >The problem I'm having is that you need to > backup this wal > file before it's been archived to have a backup which is > consistent Not sure I agree. Can you explain some more? Is it that you have a very low transaction rate and log files take a long time to fill? Please give a blow-by-blow time/event description, so we can understand what the issue is and where the window of exposure is that you can see. Best regards, Simon Riggs