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

Поиск
Список
Период
Сортировка
От bricklen
Тема Re: ERROR: could not open relation base/2757655/6930168: No such file or directory -- during warm standby setup
Дата
Msg-id AANLkTikJ=i6D8gRZd7HGWRUhc9sdoyoMHYWrNkd5T4d2@mail.gmail.com
обсуждение исходный текст
Ответ на 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>)
Список 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 по дате отправления:

Предыдущее
От: Dennis Gearon
Дата:
Сообщение: Re: uuid, COMB uuid, distributed farms
Следующее
От: Karen Springer
Дата:
Сообщение: Re: problem updating from form