Pitr ?

Hallo zusammen,
Versuche mal wieder einen PITR zu machen, klappt leider mal wieder nicht :frowning:
Folgende Fehlermeldungen finden sich im Log:

12:59:13.159 CETLOG: database system was interrupted; last known up at 2010-01-28 09:23:24 CET
12:59:13.194 CETLOG: creating missing WAL directory “pg_xlog/archive_status”
12:59:13.194 CETLOG: starting archive recovery
12:59:13.194 CETLOG: restore_command = ‘cp /pg/zpge2/arch/pg_xlog/%f “%p”’
12:59:13.216 CETLOG: recovery_target_time = ‘2010-01-28 09:13:41+01’
cp: cannot stat `/pg/zpge2/arch/pg_xlog/00000001.history’: No such file or directory
12:59:13.350 CETLOG: restored log file “0000000100000002000000B3.00E8AB80.backup” from archive
12:59:13.973 CETFATAL: the database system is starting up
12:59:13.994 CETLOG: restored log file “0000000100000002000000B5” from archive
12:59:13.995 CETLOG: automatic recovery in progress
12:59:14.384 CETLOG: restored log file “0000000100000002000000B3” from archive
12:59:14.384 CETLOG: redo starts at 2/B3E8AB80, consistency will be reached at 2/B58F4DD8
12:59:14.396 CETLOG: recovery stopping before commit of transaction 3731725, time 2010-01-28 09:22:18.851763+01
12:59:14.396 CETLOG: redo done at 2/B3E8F120
12:59:14.396 CETFATAL: requested recovery stop point is before consistent recovery point
12:59:14.397 CETLOG: startup process (PID 5041) exited with exit code 1
12:59:14.397 CETLOG: terminating any other active server processes

Auch wenn ich die recovery_target_time auf die commit transaction time (2010-01-28 09:22:18.851763+01) setzte geht es nicht??
Was mache ich falsch ?

Besten Dank für einen Tipp.
acki4711

12:59:14.396 CETFATAL: requested recovery stop point is before consistent recovery point

Du versuchst das Recovery zu einem Zeitpunkt zu stoppen, zu dem das Backup anscheinend noch gar nicht abgeschlossen war.