From: | Fujii Masao <masao(dot)fujii(at)gmail(dot)com> |
---|---|
To: | Manish Singh <delhi(dot)manish(at)gmail(dot)com> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: issue with postgresql S R slave |
Date: | 2011-05-24 17:10:52 |
Message-ID: | BANLkTinsONbPq_H3pqXwG9UOwgiG93-EXA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Ashish Kumar Singh | 2011-05-24 18:56:00 | How to remove conflicts when installing postgres where some other installation of postgres is already running using silent installer |
Previous Message | Manish Singh | 2011-05-24 15:28:36 | issue with postgresql S R slave |