Re: pglogical in postgres 9.6

Поиск
Список
Период
Сортировка
От Jeremy Finzel
Тема Re: pglogical in postgres 9.6
Дата
Msg-id CAMa1XUg9q92M8cpndpTa3MNDsGLxDW-GjXPi__S1erQi=tR-_w@mail.gmail.com
обсуждение исходный текст
Ответ на Re: pglogical in postgres 9.6  (greigwise <greigwise@comcast.net>)
Список pgsql-general

On Tue, Feb 13, 2018 at 1:46 PM greigwise <greigwise@comcast.net> wrote:
No need!  I figured it out.

Had to put this "synchronize_data := false" on the create_subscription call.
Weird that there seem to be redundant parameters for this; one on the
replication set add and one on the create subscription.  Maybe I'm not quite
understanding the usage on those or something.   If anyone knows the
difference, I'd be interested to hear.

Greig



--
Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html

Yes. When you add a subscription with sync = true, then all tables in the replication set(s) will be synced. But suppose you want to add a table later to the replication set. Sync = true will sync only that one table. So the latter is more granular.

Jeremy 

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

Предыдущее
От: armand pirvu
Дата:
Сообщение: Re: cursors and function question
Следующее
От: Alban Hertroys
Дата:
Сообщение: Re: Table Partitioning: Sequence jump issue 10 in 10 with serialdatatype