Re: [HACKERS] Logical replication existing data copy
От | Peter Eisentraut |
---|---|
Тема | Re: [HACKERS] Logical replication existing data copy |
Дата | |
Msg-id | 961aec4f-6433-d9b3-7db4-64ade6e2c818@2ndquadrant.com обсуждение исходный текст |
Ответ на | [HACKERS] Logical replication existing data copy (Petr Jelinek <petr.jelinek@2ndquadrant.com>) |
Ответы |
Re: [HACKERS] Logical replication existing data copy
Re: [HACKERS] Logical replication existing data copy |
Список | pgsql-hackers |
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? -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
В списке pgsql-hackers по дате отправления: