Re: Logical Decoding Failover

Поиск
Список
Период
Сортировка
От Venkata Balaji N
Тема Re: Logical Decoding Failover
Дата
Msg-id CAEyp7J_08ZFwV8iqcLOitqNNi2rh7Byjq-23_PbM6HS7pW+Yiw@mail.gmail.com
обсуждение исходный текст
Ответ на Logical Decoding Failover  (Colin Morelli <colin.morelli@gmail.com>)
Ответы Re: Logical Decoding Failover  (Colin Morelli <colin.morelli@gmail.com>)
Список pgsql-general
Дерево обсуждения

On Sat, Aug 6, 2016 at 1:17 PM, Colin Morelli <colin.morelli@gmail.com> wrote:
Hey all,

I'm using logical decoding in my application to capture change streams and ship them to Kafka. However, logical replication slots aren't included in the WAL and thus don't make it to replicas. In the case of a failover, it's not clear what (if anything) can be done to continue receiving a change stream.

I noticed there was a failover slot patch that looks like it won't be making it for 9.6 (if at all), but does anyone else have suggestions for handling failover + logical decoding? Is there an answer, or is it limited to being a very manual process for now?

Yes, as of i know, It is a manual process for now. Another alternative you can consider (if possible at all) would be a tool like PgPool-II which is actually used for connection pooling, load balancing and automatic failover. It may not make sense if you are do not wish to pool you connections.

Regards,
Venkata B N

Fujitsu Australia

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

Предыдущее
От: Sandeep Gupta
Дата:
Сообщение: how to serialize insert followed by read(select) by different clients
Следующее
От: Oleg Bartunov
Дата:
Сообщение: Re: Updated RUM-index and support for bigint as part of index