Re: ERROR: could not open relation base/2757655/6930168: No such file or directory -- during warm standby setup - Mailing list pgsql-general

From bricklen
Subject Re: ERROR: could not open relation base/2757655/6930168: No such file or directory -- during warm standby setup
Date
Msg-id AANLkTikJ=i6D8gRZd7HGWRUhc9sdoyoMHYWrNkd5T4d2@mail.gmail.com
Whole thread Raw
In response to Re: ERROR: could not open relation base/2757655/6930168: No such file or directory -- during warm standby setup  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
On Fri, Dec 31, 2010 at 11:53 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> I think you're missing the point here: there is something about your
> standby setup procedure that is causing you to get an inconsistent set
> of row states.

For the sake of the archives, the problem turned out to be due to
impatience. We were not waiting long enough for all the .ready files
in /data/pg_xlog/archive_status/ to be archived to the standby (noted
by those files on the master getting renamed to .done). It was taking
around 15 minutes for those files to get applied to the standby, not
the 1 minute or so that I expected.

Sorry for the noise, and thanks for the help!

pgsql-general by date:

Previous
From: Dennis Gearon
Date:
Subject: Re: uuid, COMB uuid, distributed farms
Next
From: Karen Springer
Date:
Subject: Re: problem updating from form