Impatient warm standby - Recovery spam in pg_log/startup.log

Поиск
Список
Период
Сортировка
От Joseph Marlin
Тема Impatient warm standby - Recovery spam in pg_log/startup.log
Дата
Msg-id 143945076.46824427.1340026164795.JavaMail.root@email
обсуждение исходный текст
Ответы Re: Impatient warm standby - Recovery spam in pg_log/startup.log  (roman <roman.rev@nootek.ru>)
Список pgsql-novice
We're doing a basic WAL shipping replication setup. Our Primary server ships WALs via SCP to the Warm Standby every
fiveminutes. We did the base backup, and brought Warm Standby online. The server ran through all WALs available, but
nowis spamming the startup_log with requests for the next WAL, which hasn't even been generated yet! Is this expected
behavior?If not, how can we stop it? 


cp: cannot stat `/home/ubuntu/wals/000000010000001300000042': No such file or directory
cp: cannot stat `/home/ubuntu/wals/000000010000001300000042': No such file or directory
cp: cannot stat `/home/ubuntu/wals/000000010000001300000042': No such file or directory
cp: cannot stat `/home/ubuntu/wals/000000010000001300000042': No such file or directory
cp: cannot stat `/home/ubuntu/wals/000000010000001300000042': No such file or directory
cp: cannot stat `/home/ubuntu/wals/000000010000001300000042': No such file or directory
cp: cannot stat `/home/ubuntu/wals/000000010000001300000042': No such file or directory
cp: cannot stat `/home/ubuntu/wals/000000010000001300000042': No such file or directory
cp: cannot stat `/home/ubuntu/wals/000000010000001300000042': No such file or directory
cp: cannot stat `/home/ubuntu/wals/000000010000001300000042': No such file or directory
cp: cannot stat `/home/ubuntu/wals/000000010000001300000042': No such file or directory
cp: cannot stat `/home/ubuntu/wals/000000010000001300000042': No such file or directory
cp: cannot stat `/home/ubuntu/wals/000000010000001300000042': No such file or directory
cp: cannot stat `/home/ubuntu/wals/000000010000001300000042': No such file or directory
cp: cannot stat `/home/ubuntu/wals/000000010000001300000042': No such file or directory
cp: cannot stat `/home/ubuntu/wals/000000010000001300000042': No such file or directory
cp: cannot stat `/home/ubuntu/wals/000000010000001300000042': No such file or directory
cp: cannot stat `/home/ubuntu/wals/000000010000001300000042': No such file or directory
cp: cannot stat `/home/ubuntu/wals/000000010000001300000042': No such file or directory
LOG:  restored log file "000000010000001300000042" from archive
cp: cannot stat `/home/ubuntu/wals/000000010000001300000043': No such file or directory
cp: cannot stat `/home/ubuntu/wals/000000010000001300000043': No such file or directory
cp: cannot stat `/home/ubuntu/wals/000000010000001300000043': No such file or directory
cp: cannot stat `/home/ubuntu/wals/000000010000001300000043': No such file or directory
cp: cannot stat `/home/ubuntu/wals/000000010000001300000043': No such file or directory
cp: cannot stat `/home/ubuntu/wals/000000010000001300000043': No such file or directory
cp: cannot stat `/home/ubuntu/wals/000000010000001300000043': No such file or directory
cp: cannot stat `/home/ubuntu/wals/000000010000001300000043': No such file or directory
cp: cannot stat `/home/ubuntu/wals/000000010000001300000043': No such file or directory
cp: cannot stat `/home/ubuntu/wals/000000010000001300000043': No such file or directory
cp: cannot stat `/home/ubuntu/wals/000000010000001300000043': No such file or directory
cp: cannot stat `/home/ubuntu/wals/000000010000001300000043': No such file or directory
cp: cannot stat `/home/ubuntu/wals/000000010000001300000043': No such file or directory
cp: cannot stat `/home/ubuntu/wals/000000010000001300000043': No such file or directory
cp: cannot stat `/home/ubuntu/wals/000000010000001300000043': No such file or directory
cp: cannot stat `/home/ubuntu/wals/000000010000001300000043': No such file or directory
cp: cannot stat `/home/ubuntu/wals/000000010000001300000043': No such file or directory
cp: cannot stat `/home/ubuntu/wals/000000010000001300000043': No such file or directory
cp: cannot stat `/home/ubuntu/wals/000000010000001300000043': No such file or directory
cp: cannot stat `/home/ubuntu/wals/000000010000001300000043': No such file or directory
cp: cannot stat `/home/ubuntu/wals/000000010000001300000043': No such file or directory


Thanks!

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

Предыдущее
От: Jeff Davis
Дата:
Сообщение: Re: Planning a Large RDBMS
Следующее
От: Lew
Дата:
Сообщение: Re: select from multiple tables