Re: Remaining Streaming Replication Open Items

Поиск
Список
Период
Сортировка
От Fujii Masao
Тема Re: Remaining Streaming Replication Open Items
Дата
Msg-id l2l3f0b79eb1004140132p31cf6416ka76de09d59fa0564@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Remaining Streaming Replication Open Items  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
Ответы Re: Remaining Streaming Replication Open Items
Список pgsql-hackers
On Wed, Apr 14, 2010 at 12:49 AM, Heikki Linnakangas
<heikki.linnakangas@enterprisedb.com> wrote:
> We have the emode_for_corrupt_record() function that's used in all the
> errors that indicate a corrupt WAL record, that's a perfect place to
> hook this into. See attached patch.

One problem of the patch is that even if the content of error message
is different from the past, it would be skipped when the location of
invalid record is the same of the past. For example, if there is a
partially-filled unbroken WAL file in the standby, the following
message would be written:
   record with zero length at %X/%X

Then if you drop corrupted WAL file into pg_xlog, the following message
might have to be output, but would be skipped:
   invalid magic number %04X in log file %u, segment %u, offset %u


But I think that we might be able to live with the issue since it's
a very corner case.

Regards,

-- 
Fujii Masao
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
NTT Open Source Software Center


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

Предыдущее
От: Stefan Kaltenbrunner
Дата:
Сообщение: Re: a faster compression algorithm for pg_dump
Следующее
От: Dimitri Fontaine
Дата:
Сообщение: Re: testing HS/SR - 1 vs 2 performance