Impatient warm standby - Recovery spam in pg_log/startup.log - Mailing list pgsql-novice

From Joseph Marlin
Subject Impatient warm standby - Recovery spam in pg_log/startup.log
Date
Msg-id 143945076.46824427.1340026164795.JavaMail.root@email
Whole thread Raw
Responses Re: Impatient warm standby - Recovery spam in pg_log/startup.log
List 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 by date:

Previous
From: Jeff Davis
Date:
Subject: Re: Planning a Large RDBMS
Next
From: Lew
Date:
Subject: Re: select from multiple tables