X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 83587D97FD for ; Fri, 4 Nov 2005 17:50:38 -0400 (AST) 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 03081-07 for ; Fri, 4 Nov 2005 21:50:35 +0000 (GMT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mail.space.net (mail.Space.Net [195.30.0.8]) by svr1.postgresql.org (Postfix) with SMTP id 69DF6D97BD for ; Fri, 4 Nov 2005 17:50:36 -0400 (AST) Received: (qmail 86658 invoked from network); 4 Nov 2005 21:43:17 -0000 Received: from fw-ri1a.rhm.de (HELO node130.rhm.de) (193.149.57.189) by mail.space.net with SMTP; 4 Nov 2005 21:43:17 -0000 Received: from [194.97.83.35] (lbernd.rhm.de [194.97.83.35]) by node130.rhm.de (8.9.3 (PHNE_28760)/8.8.6) with ESMTP id WAA09006 for ; Fri, 4 Nov 2005 22:43:16 +0100 (MET) Message-ID: <436BD5F4.3090108@rhm.de> Date: Fri, 04 Nov 2005 22:43:16 +0100 From: Bernd Rieke User-Agent: Mozilla Thunderbird 1.0 (X11/20041206) X-Accept-Language: de-DE, de, en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: PITR recover ends unexpected Content-Type: text/plain; charset=ISO-8859-15; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0 required=5 tests=[none] X-Spam-Score: 0 X-Spam-Level: X-Archive-Number: 200511/44 X-Sequence-Number: 19417 Hi, since some month we use PITR and it works fine. We make a base backup once a week. For testing if everything will work when needed we replay the wal files every day to the base backup on a second machine. It works fine except for two time when we saw a strange problem. The recovery process stated a zero length record in the wal file and stop 'as expected' as it told us. The recovered database was useable but we had a gap in the recovered data from the time it stops replaying wal files up to the next base backup. We didn't see any hardware problems or problems while copying the wal files to the second machine. So our question is if anybody out there saw a similar problem. Thanks in advance for your replies Bernd Rieke