Re: issue with postgresql S R slave

On Wed, May 25, 2011 at 12:28 AM, Manish Singh <delhi(dot)manish(at)gmail(dot)com> wrote:
> I am having a problem with all slaves...i am not sure it's a bug or my side
> configuration problem..
>
> 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

These messages mean that the standby just could not find and read the WAL
file (000000010000000300000026) from the archive. But this is not a problem.
That WAL file would be available in the master, so the standby can read it from
the master via streaming replication. Which is a normal operation.

Regards,

--
Fujii Masao
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
NTT Open Source Software Center