Re: many "cp: cannot stat xxx No such file or directory" logs in warm standby

Thank you, Ian.

Is there a way to get rid of these msgs?

Regards,
Yahoon

On Mon, Sep 28, 2020 at 1:28 PM Ian Barwick <ian(dot)barwick(at)2ndquadrant(dot)com>
wrote:

> On 2020/09/28 14:12, Hong Yao wrote:
> > Hi all
> >
> > I am setting up a standby server for my PG-12.4 primary server,
> following the doc
> https://www.postgresql.org/docs/12/warm-standby.html#STANDBY-SERVER-SETUP (26.2.4.
> Setting Up a Standby Server"
> > The OSes are CentOS-7.8
> >
> > The steps on the standby:
>
> (...)
>
> > * set restore command in postgresql.conf
> > o / restore_command = 'cp /var/pg_wal_archive/%f %p' /
> > o / archive_cleanup_command = 'pg_archivecleanup
> /var/pg_wal_archive %r'/
>
> (...)
>
> > But in the standalone logs, i see following errors keep repeating:
> >
> > /cp: cannot stat ‘/var/pg_wal_archive/000000020000000000000014’: No
> such file or directory/
> > /cp: cannot stat ‘/var/pg_wal_archive/00000003.history’: No such
> file or directory/
>
> This is expected, as PostgreSQL is speculatively looking for files which
> may have
> arrived since the last check.
>
> Per the documentation [1]:
>
> "The command will be asked for file names that are not present in the
> archive"
>
> [1]
> https://www.postgresql.org/docs/current//runtime-config-wal.html#GUC-RESTORE-COMMAND
>
>
> Regards
>
> Ian Barwick
>
>
> --
> Ian Barwick https://www.2ndQuadrant.com/
> PostgreSQL Development, 24x7 Support, Training & Services
>