Re: [HACKERS] Logical replication existing data copy

Поиск
Список
Период
Сортировка
От Craig Ringer
Тема Re: [HACKERS] Logical replication existing data copy
Дата
Msg-id CAMsr+YEUryigUb4ZaFv-WtKBo1Vhumff3Qm-PBtWz3UY7FHEMw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [HACKERS] Logical replication existing data copy  (Peter Eisentraut <peter.eisentraut@2ndquadrant.com>)
Список pgsql-hackers
Дерево обсуждения
On 20 Dec. 2016 1:27 am, "Peter Eisentraut" <peter.eisentraut@2ndquadrant.com> wrote:
On 12/19/16 4:30 AM, Petr Jelinek wrote:
> So existing table data can be copied once subscription is created, but
> also new tables can be added and their data copied. This is where the
> REFRESH PUBLICATION comes into play. Adding table to publication does
> not make it automatically replicated by the subscription as the
> subscription does not have tracking info for that table. So to add new
> table user must call ALTER SUBSCRIPTION ... REFRESH PUBLICATION on
> subscriber otherwise the data won't be replicated.

Couldn't the subscriber automatically add tracking info when apply
stream data arrives for a relation it has not seen before?

If no table has been created by the user and we start trying to apply a data stream apply will break.

Since manual action is needed to create the destination I don't see a problem with requiring manual enabling too, personally.

Let the fully transparent way wait until we can do DDL replication in v11+

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

Предыдущее
От: Thomas Munro
Дата:
Сообщение: Re: [HACKERS] Creating a DSA area to provide work space for parallel execution
Следующее
От: Amit Langote
Дата:
Сообщение: Re: [HACKERS] Minor correction in alter_table.sgml