Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group