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
