Hi All,
Trying to do a PITR on postgres 8.1.8; I've restored the last full
backup of the cluster dir and put the required WAL files into place.
Yet when I attempt the recovery I see the following:
Jun 18 15:44:11 postgres[29730]: [3-1] LOG: starting archive recovery
Jun 18 15:44:11 postgres[29730]: [4-1] LOG: restore_command = "cp /
var/lib/pgsql/backups/oldwal/%f %p"
Jun 18 15:44:11 postgres[29730]: [5-1] LOG: recovery_target_time =
2007-06-16 22:00:00+09:30
Jun 18 15:44:11 postgres[29730]: [6-1] LOG: restored log file
"000000010000000000000002.00DD29D8.backup" from archive
Jun 18 15:44:11 postgres[29730]: [7-1] LOG: restored log file
"000000010000000000000002" from archive
Jun 18 15:44:11 postgres[29730]: [8-1] LOG: checkpoint record is at
0/2DD29D8
Jun 18 15:44:11 postgres[29730]: [9-1] LOG: redo record is at
0/2DD29D8; undo record is at 0/0; shutdown FALSE
Jun 18 15:44:11 postgres[29730]: [10-1] LOG: next transaction ID:
4236; next OID: 32591
Jun 18 15:44:11 postgres[29730]: [11-1] LOG: next MultiXactId: 1;
next MultiXactOffset: 0
Jun 18 15:44:11 postgres[29730]: [12-1] LOG: automatic recovery in
progress
Jun 18 15:44:11 postgres[29730]: [13-1] LOG: redo starts at 0/2DD2A1C
Jun 18 15:44:13 postgres[29730]: [14-1] LOG: restored log file
"000000010000000000000003" from archive
...
Jun 18 15:44:39 postgres[29730]: [49-1] LOG: restored log file
"000000010000000000000026" from archive
Jun 18 15:44:39 postgres[29730]: [50-1] LOG: recovery stopping
before commit of transaction 1809419, time 2007-06-16 22:24:47 CST
Jun 18 15:44:39 postgres[29730]: [51-1] LOG: redo done at 0/264A55A0
Jun 18 15:44:39 postgres[29730]: [52-1] LOG: selected new timeline
ID: 2
Jun 18 15:44:39 postgres[29730]: [53-1] LOG: archive recovery complete
Jun 18 15:44:39 postgres[29730]: [54-1] LOG: could not fsync segment
0 of relation 1663/42607/44092: No such file or directory
Jun 18 15:44:39 postgres[29730]: [55-1] PANIC: storage sync failed
on magnetic disk: No such file or directory
Jun 18 15:44:39 postgres[29726]: [2-1] LOG: startup process (PID
29730) was terminated by signal 6
Jun 18 15:44:39 postgres[29726]: [3-1] LOG: aborting startup due to
startup process failure
Any ideas?
I'm not a subscriber so please cc: me on any responses.
Regards,
Tom
--
Tom Lanyon
Systems Administrator
NetSpot Pty Ltd
