From: | Sebastian Böhm <pg(at)seb(dot)exse(dot)net> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | warm standby question |
Date: | 2013-02-28 20:35:11 |
Message-ID: | 757DAF0D-4B2D-4DFB-94CA-00700B2CA03F@seb.exse.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | G B | 2013-02-28 20:38:03 | Connection limit exceeded for non-superusers when there are plenty of available slots |
Previous Message | Adrian Klaver | 2013-02-28 20:16:23 | Re: postgresql log file not getting update |