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

From: bricklen <bricklen(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: ERROR: could not open relation base/2757655/6930168: No such file or directory -- during warm standby setup
Date: 2011-01-03 05:59:28
Message-ID: AANLkTikJ=i6D8gRZd7HGWRUhc9sdoyoMHYWrNkd5T4d2@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Dec 31, 2010 at 11:53 AM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)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!

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Karen Springer 2011-01-03 06:29:49 Re: problem updating from form
Previous Message Dennis Gearon 2011-01-03 04:56:28 Re: uuid, COMB uuid, distributed farms