Re: postgresql recovery (PANIC: btree_split_redo: lost left sibling)

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Sipos Ferenc" <sipos(dot)ferenc(at)telefor(dot)hu>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: postgresql recovery (PANIC: btree_split_redo: lost left sibling)
Date: 2007-05-31 17:54:04
Message-ID: 10712.1180634044@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

"Sipos Ferenc" <sipos(dot)ferenc(at)telefor(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Jonah H. Harris 2007-05-31 18:53:14 Re: Deletes hurt
Previous Message Sipos Ferenc 2007-05-31 17:44:12 Re: postgresql recovery (PANIC: btree_split_redo: lost left sibling)