Hi, I have a primary server (9.1), which does wal archiving like this:
wal_level = hot_standby archive_mode = on archive_command = 'test ! -f /home/autobackup/wal/%f && cp %p /home/autobackup/wal/%f' then I have a warm standby with this configuration in recovery.conf: restore_command = 'cp /opt/WAL/%f %p' standby_mode = on when I then start the server it applies all WAL files. But when I then stop the server after a few minutes and start it again, it asks for a WAL file it already processed. Logfile: 2013-02-28 16:21:00 CET LOG: database system was shut down in recovery at 2013-02-28 16:20:53 CET 2013-02-28 16:21:00 CET LOG: entering standby mode 2013-02-28 16:21:00 CET LOG: incomplete startup packet ---> 2013-02-28 16:21:00 CET LOG: restored log file "0000000100000007000000C0" from archive 2013-02-28 16:21:00 CET LOG: redo starts at 7/C0F9A650 2013-02-28 16:21:00 CET LOG: consistent recovery state reached at 7/C0FFE398 cp: cannot stat `/opt/WAL/0000000100000007000000C1': No such file or directory cp: cannot stat `/opt/WAL/0000000100000007000000C1': No such file or directory 2013-02-28 16:21:01 CET FATAL: the database system is starting up 2013-02-28 16:21:01 CET FATAL: the database system is starting up 2013-02-28 16:21:02 CET FATAL: the database system is starting up 2013-02-28 16:21:02 CET FATAL: the database system is starting up 2013-02-28 16:21:03 CET FATAL: the database system is starting up 2013-02-28 16:21:03 CET FATAL: the database system is starting up 2013-02-28 16:21:04 CET FATAL: the database system is starting up 2013-02-28 16:21:04 CET FATAL: the database system is starting up 2013-02-28 16:21:05 CET FATAL: the database system is starting up cp: cannot stat `/opt/WAL/0000000100000007000000C1': No such file or directory 2013-02-28 16:21:05 CET FATAL: the database system is starting up 2013-02-28 16:21:06 CET FATAL: the database system is starting up 2013-02-28 16:21:06 CET LOG: incomplete startup packet 2013-02-28 16:21:08 CET LOG: received fast shutdown request 2013-02-28 16:21:08 CET LOG: shutting down 2013-02-28 16:21:08 CET LOG: database system is shut down 2013-02-28 16:21:12 CET LOG: database system was shut down in recovery at 2013-02-28 16:21:08 CET 2013-02-28 16:21:12 CET LOG: entering standby mode ----> 2013-02-28 16:21:12 CET LOG: restored log file "0000000100000007000000C0" from archive 2013-02-28 16:21:12 CET LOG: redo starts at 7/C0F9A650 2013-02-28 16:21:12 CET LOG: consistent recovery state reached at 7/C0FFE398 cp: cannot stat `/opt/WAL/0000000100000007000000C1': No such file or directory cp: cannot stat `/opt/WAL/0000000100000007000000C1': No such file or directory 2013-02-28 16:21:12 CET LOG: incomplete startup packet 2013-02-28 16:21:13 CET FATAL: the database system is starting up 2013-02-28 16:21:13 CET FATAL: the database system is starting up 2013-02-28 16:21:14 CET FATAL: the database system is starting up 2013-02-28 16:21:14 CET FATAL: the database system is starting up 2013-02-28 16:21:15 CET FATAL: the database system is starting up 2013-02-28 16:21:15 CET FATAL: the database system is starting up 2013-02-28 16:21:16 CET FATAL: the database system is starting up 2013-02-28 16:21:17 CET FATAL: the database system is starting up 2013-02-28 16:21:17 CET FATAL: the database system is starting up cp: cannot stat `/opt/WAL/0000000100000007000000C1': No such file or directory 2013-02-28 16:21:18 CET FATAL: the database system is starting up 2013-02-28 16:21:18 CET FATAL: the database system is starting up 2013-02-28 16:21:18 CET LOG: incomplete startup packet cp: cannot stat `/opt/WAL/0000000100000007000000C1': No such file or directory cp: cannot stat `/opt/WAL/0000000100000007000000C1': No such file or directory thanks sebastian -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
