warm standby question

Поиск
Список
Период
Сортировка
От Sebastian Böhm
Тема warm standby question
Дата
Msg-id 757DAF0D-4B2D-4DFB-94CA-00700B2CA03F@seb.exse.net
обсуждение исходный текст
Ответы Re: warm standby question  (Albe Laurenz <laurenz.albe@wien.gv.at>)
Список 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




В списке pgsql-general по дате отправления:

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: postgresql log file not getting update
Следующее
От: G B
Дата:
Сообщение: Connection limit exceeded for non-superusers when there are plenty of available slots