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

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: ERROR: could not open relation base/2757655/6930168: No such file or directory -- during warm standby setup
Дата
Msg-id 29632.1293651321@sss.pgh.pa.us
обсуждение исходный текст
Ответ на ERROR: could not open relation base/2757655/6930168: No such file or directory -- during warm standby setup  (bricklen <bricklen@gmail.com>)
Ответы Re: ERROR: could not open relation base/2757655/6930168: No such file or directory -- during warm standby setup  (bricklen <bricklen@gmail.com>)
Список pgsql-general
bricklen <bricklen@gmail.com> writes:
> After setting up a warm standby
> (pg_start_backup/rsync/pg_stop_backup), and promoting to master, we
> encountered an error in the middle of an analyze of the new standby
> db. (the standby server is a fresh server)
> [ relfilenode doesn't match on source and standby ]

What can you tell us about what was happening on the source DB while
the backup was being taken?  In particular I'm wondering if anything
that would've given offer2offer a new relfilenode was in progress.
Also, does the pg_class entry for offer2offer have the same xmin and
ctid in both DBs?

            regards, tom lane

В списке pgsql-general по дате отправления:

Предыдущее
От: "Tim Bruce - Postgres"
Дата:
Сообщение: Re: Restore problem
Следующее
От: bricklen
Дата:
Сообщение: Re: ERROR: could not open relation base/2757655/6930168: No such file or directory -- during warm standby setup