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: