Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 67DC19FB7FF for ; Thu, 31 May 2007 14:19:25 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 38610-02 for ; Thu, 31 May 2007 14:19:18 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from is.rice.edu (is.rice.edu [128.42.42.24]) by postgresql.org (Postfix) with ESMTP id 58CAE9FBA7A for ; Thu, 31 May 2007 14:19:12 -0300 (ADT) Received: from scan2.mail.rice.edu (scan2.mail.rice.edu [128.42.59.161]) by is.rice.edu (Postfix) with ESMTP id 483E54181D; Thu, 31 May 2007 12:19:11 -0500 (CDT) Received: from is.rice.edu ([128.42.42.24]) by scan2.mail.rice.edu (scan2.mail.rice.edu [128.42.59.161]) (amavisd-new, port 10024) with ESMTP id 19351-09; Thu, 31 May 2007 12:19:10 -0500 (CDT) Received: by is.rice.edu (Postfix, from userid 18612) id 8DFBF41819; Thu, 31 May 2007 12:19:10 -0500 (CDT) Date: Thu, 31 May 2007 12:19:10 -0500 From: Kenneth Marshall To: Sipos Ferenc Cc: pgsql-admin@postgresql.org Subject: Re: postgresql recovery (PANIC: btree_split_redo: lost left sibling) Message-ID: <20070531171910.GV7069@it.is.rice.edu> References: <0E1D39D78C8CE14A96A6B6EF2192E463D3046D@telefor-server.int.telefor-new.hu> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <0E1D39D78C8CE14A96A6B6EF2192E463D3046D@telefor-server.int.telefor-new.hu> User-Agent: Mutt/1.4.2i X-Virus-Scanned: by amavis-2.2.1 at scan2.mail.rice.edu X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200705/341 X-Sequence-Number: 25661 You may want to give the latest version of 8.0 a try 8.0.13. Ken On Thu, May 31, 2007 at 06:14:05PM +0200, Sipos Ferenc wrote: > Hello, > > I have a problem with postgresql recovery. I want to make a test > recovery from our production server to a test machine. On the production > server runs PostgreSQL 8.0.3. On the test machine the PostgreSQL version > is 8.0.4 (installed from binary rpm).