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).
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 the full log:
2007-05-31 17:53:49 CEST () (15606): LOG: database system was
interrupted at 2007-05-31 12:35:04 CEST
2007-05-31 17:53:49 CEST () (15606): LOG: starting archive recovery
2007-05-31 17:53:49 CEST () (15606): LOG: restore_command = "cp
/var/lib/pgsql/old_wal_logs/%f "%p""
2007-05-31 17:53:49 CEST () (15606): LOG: recovery_target_timeline =
latest
cp: cannot stat `/var/lib/pgsql/old_wal_logs/00000002.history': No such
file or directory
cp: cannot stat `/var/lib/pgsql/old_wal_logs/00000001.history': No such
file or directory
2007-05-31 17:53:49 CEST () (15606): LOG: restored log file
"0000000100000041000000A1.00CD7CF0.backup" from archive
2007-05-31 17:53:49 CEST () (15606): LOG: restored log file
"0000000100000041000000A1" from archive
2007-05-31 17:53:49 CEST () (15606): LOG: checkpoint record is at
41/A1CEA2BC
2007-05-31 17:53:49 CEST () (15606): LOG: redo record is at
41/A1CD7CF0; undo record is at 0/0; shutdown FALSE
2007-05-31 17:53:49 CEST () (15606): LOG: next transaction ID:
598101301; next OID: 22784393
2007-05-31 17:53:49 CEST () (15606): LOG: automatic recovery in
progress
2007-05-31 17:53:49 CEST () (15606): LOG: redo starts at 41/A1CD7CF0
2007-05-31 17:55:08 CEST () (15606): PANIC: btree_split_redo: lost left
sibling
2007-05-31 17:55:08 CEST () (15603): LOG: startup process (PID 15606)
was terminated by signal 6
2007-05-31 17:55:08 CEST () (15603): LOG: aborting startup due to
startup process failure
2007-05-31 17:55:09 CEST () (15605): LOG: logger shutting down
I try to made a test recovery following the instructions I read on this
page: http://www.postgresql.org/docs/8.0/interactive/backup-online.html
How can I start the server?
Thank you your help.
Best Regards,
Ferenc Sipos