Re: Postgresql 9.1 replication failing

Поиск
Список
Период
Сортировка
От Robert Haas
Тема Re: Postgresql 9.1 replication failing
Дата
Msg-id CA+TgmobFiu9tDy7HFSz=01vxqH_gmAvtPGFg-a_z3M4aigpRkQ@mail.gmail.com
обсуждение исходный текст
Ответ на Postgresql 9.1 replication failing  (Jim Buttafuoco <jim@contacttelecom.com>)
Список pgsql-hackers
On Thu, Dec 1, 2011 at 1:41 PM, Jim Buttafuoco <jim@contacttelecom.com> wrote:
> 2011-12-01 07:46:30 EST  >LOG:  restored log file "000000010000028E000000E5" from archive
> 2011-12-01 07:46:30 EST  >LOG:  incorrect resource manager data checksum in record at 28E/E555E1B8
>
> Anything I can do on the replica or do I have to start over?

I think you want to rebuild the standby.  Even if you could repair the
damaged WAL record, how can you have any confidence that there is no
other corruption?

Note that rsync has some options to only copy the changed data, which
might greatly accelerated resyncing the standby from the master.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


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

Предыдущее
От: Jim Buttafuoco
Дата:
Сообщение: Postgresql 9.1 replication failing
Следующее
От: Jerry Sievers
Дата:
Сообщение: Re: Postgresql 9.1 replication failing