On Wed, May 25, 2011 at 12:28 AM, Manish Singh <delhi.man...@gmail.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 -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
