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 ---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate
