loss of transactions in streaming replication

Поиск
Список
Период
Сортировка
От Fujii Masao
Тема loss of transactions in streaming replication
Дата
Msg-id CAHGQGwEEm1TpNZvuMh08ZB2kVCvyAeFkdUwdXPJYYC8jaf_N1A@mail.gmail.com
обсуждение исходный текст
Ответы Re: loss of transactions in streaming replication
Список pgsql-hackers
Hi,

In 9.2dev and 9.1, when walreceiver detects an error while sending data to
WAL stream, it always emits ERROR even if there are data available in the
receive buffer. This might lead to loss of transactions because such
remaining data are not received by walreceiver :(

To prevent transaction loss, I'm thinking to change walreceiver so that it
always ignores an error (specifically, emits COMMERROR instead of ERROR)
during sending data. Then walreceiver receives data if available. If an error
occurrs during receiving data, walreceiver can emit ERROR this time.
Comments? Better ideas?

Regards,

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


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

Предыдущее
От: Amit Khandekar
Дата:
Сообщение: pl/perl example in the doc no longer works in 9.1
Следующее
От: Kohei KaiGai
Дата:
Сообщение: Re: [v9.2] DROP statement reworks