Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Fri, Dec 31, 2010 at 11:53 AM, Tom Lane <tgl@xxxxxxxxxxxxx> 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!

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux