Re: BUG #6037: error on restarting slave - cp: cannot stat `pg_xlog....`: no such file or ...

On 24.05.2011 18:27, manish singh wrote:
> When ever i am restarting postgresql slave  (Service postgresql restart -
> made a script) or even just stopping and starting a postgresql slave.. it
> displays a a message, although slave get's started and working fine...
>
> server starting
> cp: cannot stat
> `/usr/local/pgsql/data/pg_xlogarch/000000010000000300000026': No such file
> or directory
> cp: cannot stat
> `/usr/local/postgres/data/pg_xlogarch/000000010000000300000026': No such
> file or directory

The standby server periodically checks if new WAL has arrived by
executing the restore_command. Your restore_command uses 'cp', which
prints out that message if the target file can't be found.

In other words, your system seems to be working correctly, and those
messages are harmless. You could silence it by replacing plain 'cp' with
a shell script that checks if the file exists first and calls 'cp' only
if it does.

--
   Heikki Linnakangas
   EnterpriseDB   http://www.enterprisedb.com