Re: Stream consistent snapshot via a logical decoding plugin as a series of INSERTs

Поиск
Список
Период
Сортировка
От Shulgin, Oleksandr
Тема Re: Stream consistent snapshot via a logical decoding plugin as a series of INSERTs
Дата
Msg-id CACACo5R3eUKrTKbNhaT29ACdPiGt+DjxOsaZPqSFDUWFFScHZQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Stream consistent snapshot via a logical decoding plugin as a series of INSERTs  (Simon Riggs <simon@2ndQuadrant.com>)
Ответы Re: Stream consistent snapshot via a logical decoding plugin as a series of INSERTs  ("Shulgin, Oleksandr" <oleksandr.shulgin@zalando.de>)
Список pgsql-hackers
Дерево обсуждения
On Fri, Jan 15, 2016 at 11:08 AM, Simon Riggs <simon@2ndquadrant.com> wrote:
On 15 January 2016 at 08:30, Shulgin, Oleksandr <oleksandr.shulgin@zalando.de> wrote:
 
I'd like to propose generic functions (probably in an extension, or in core if not possible otherwise) to facilitate streaming existing data from the database *in the same format* that one would get if these would be the changes decoded by a logical decoding plugin.

The idea is to use a snapshot returned from CREATE_REPLICATION_SLOT command of the replication protocol to get a consistent snapshot of the database, then start listening to new changes on the slot.

It sounds like this is already possible. 

Totally, that's how it was supposed to be used anyway.  What is missing IMO is retrieving the initial snapshot in the same format as that the later changes will arrive.

--
Alex

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

Предыдущее
От: Vladimir Sitnikov
Дата:
Сообщение: Re: Insert values() per-statement overhead
Следующее
От: Damien Clochard
Дата:
Сообщение: Invitation to the OSGEO Code Sprint 2016 / Feb 23-26 in Paris