I am testing PITR, following the instructions in:
"23.3.3. Recovering with
an On-line Backup." In step 9 I inspect the database and find that it is
working perfectly. All the data from the original is present and I am able
to create a new table and insert rows. The problem is that there are errors
in the log as follows:
########################################
...
2009-09-23 13:32:32 PDT::@[11675]:LOG: restored log file
"00000003000000EF000000A5" from archive
cp: cannot stat
`/home/postgres/data/pnp/pgsql8.3.3/mnt/data/pns/pgsql8.3.3/archive_log/00000003000000EF000000A6':
No such file or directory
2009-09-23 13:32:32 PDT::@[11675]:LOG: record with zero length at
EF/A6000560
2009-09-23 13:32:32 PDT::@[11675]:LOG: redo done at EF/A6000530
2009-09-23 13:32:32 PDT::@[11675]:LOG: last completed transaction was at
log time 2009-09-23 13:32:51.364195-07
cp: cannot stat
`/home/postgres/data/pnp/pgsql8.3.3/mnt/data/pns/pgsql8.3.3/archive_log/00000003000000EF000000A6':
No such file or directory
cp: cannot stat
`/home/postgres/data/pnp/pgsql8.3.3/mnt/data/pns/pgsql8.3.3/archive_log/00000004.history':
No such file or directory
2009-09-23 13:32:32 PDT::@[11675]:LOG: selected new timeline ID: 4
2009-09-23 13:32:32 PDT::@[11675]:LOG: restored log file
"00000003.history"
from archive
2009-09-23 13:32:32 PDT::@[11675]:LOG: archive recovery complete
2009-09-23 13:32:32 PDT::@[11675]:LOG: checkpoint starting: shutdown
immediate
2009-09-23 13:32:33 PDT::@[11675]:LOG: checkpoint complete: wrote 824
buffers (2.5%); 0 transaction log file(s) added, 0 removed, 0 recycled;
write=0.010 s, sync=0.336 s, total=0.356 s
2009-09-23 13:32:33 PDT::@[11759]:LOG: autovacuum launcher started
2009-09-23 13:32:33 PDT::@[11673]:LOG: database system is ready to accept
connections
########################################
When I check the WAL file directories I find that all is in order. The file
00000004.history does not exist, but it is not supposed to exist. The file
00000003000000EF000000A6 is not in the backup archive (archive_log) because
it had not been moved there yet at the time I did the pitr. It is in the
current archive (pg_xlog), where it should be. Here is a listing of those
directories:
########################################
> ls archive_log/
...
00000003000000A100000024.0001F538.backup
00000003000000EE00000097
00000003000000EF000000A2
00000003000000A1000000B5.0001B730.backup
00000003000000EE00000098
00000003000000EF000000A3
00000003000000A200000047.0001EE70.backup
00000003000000EE00000099
00000003000000EF000000A4
00000003000000A2000000D8.0001B938.backup
00000003000000EE0000009A
00000003000000EF000000A5
00000003000000A30000006A.00020230.backup
00000003000000EE0000009B
00000003.history
ls ../archive_log/*history
../archive_log/00000002.history ../archive_log/00000003.history
> ls ../pg_xlog/
00000002.history
00000003000000EF000000A6
00000003000000EF000000A9 00000003000000EF000000AC
00000003000000EF0000005D.000000D8.backup 00000003000000EF000000A7
00000003000000EF000000AA 00000003.history
00000003000000EF000000A5
00000003000000EF000000A8
00000003000000EF000000AB archive_status
> ls ../pg_xlog/*
../pg_xlog/00000002.history
../pg_xlog/00000003000000EF000000A7 ../pg_xlog/00000003000000EF000000AB
../pg_xlog/00000003000000EF0000005D.000000D8.backup
../pg_xlog/00000003000000EF000000A8 ../pg_xlog/00000003000000EF000000AC
../pg_xlog/00000003000000EF000000A5
../pg_xlog/00000003000000EF000000A9 ../pg_xlog/00000003.history
../pg_xlog/00000003000000EF000000A6
../pg_xlog/00000003000000EF000000AA
../pg_xlog/archive_status:
00000002.history.done 00000003000000EF0000005D.000000D8.backup.done
00000003000000EF000000A5.done 00000003.history.done
########################################
So, my question is, can I ignore these error messages and assume that the
pitr worked and all is fine?
Lou ...
Thanks,
Lou ... x69925