Postgres Pro
Downloads
Home   >   mailing lists

Re: postgresql recovery (PANIC: btree_split_redo: lost left sibling) - Mailing list pgsql-admin

From Tom Lane
Subject Re: postgresql recovery (PANIC: btree_split_redo: lost left sibling)
Date
Msg-id 10712.1180634044@sss.pgh.pa.us
Whole thread Raw
In response to postgresql recovery (PANIC: btree_split_redo: lost left sibling)  ("Sipos Ferenc" <sipos.ferenc@telefor.hu>)
List pgsql-admin
Tree view 
"Sipos Ferenc" <sipos.ferenc@telefor.hu> writes:
> 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).
> I issued pg_start_backup and make a file system backup and issued
> pg_stop_backup. I unpacked the file system backup to the test machine I
> copied the new WAL logs to a directory. When I want to start the server
> on the test machine I got an error: PANIC:  btree_split_redo: lost left
> sibling

This is a known bug repaired in 8.0.8 and up.

            regards, tom lane

pgsql-admin by date:

Previous
From: "Sipos Ferenc"
Date:
Subject: Re: postgresql recovery (PANIC: btree_split_redo: lost left sibling)
Next
From: "Jonah H. Harris"
Date:
Subject: Re: Deletes hurt