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

From: Joseph Marlin <jmarlin(at)saucontech(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Impatient warm standby - Recovery spam in pg_log/startup.log
Date: 2012-06-18 13:29:24
Message-ID: 143945076.46824427.1340026164795.JavaMail.root@email
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

We're doing a basic WAL shipping replication setup. Our Primary server ships WALs via SCP to the Warm Standby every five minutes. We did the base backup, and brought Warm Standby online. The server ran through all WALs available, but now is 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!

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Lew 2012-06-18 13:43:46 Re: select from multiple tables
Previous Message Jeff Davis 2012-06-17 06:56:22 Re: Planning a Large RDBMS