Re: pglogical in postgres 9.6 - Mailing list pgsql-general

From Jeremy Finzel
Subject Re: pglogical in postgres 9.6
Date
Msg-id CAMa1XUg9q92M8cpndpTa3MNDsGLxDW-GjXPi__S1erQi=tR-_w@mail.gmail.com
Whole thread Raw
In response to Re: pglogical in postgres 9.6  (greigwise <greigwise@comcast.net>)
List 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 by date:

Previous
From: armand pirvu
Date:
Subject: Re: cursors and function question
Next
From: Alban Hertroys
Date:
Subject: Re: Table Partitioning: Sequence jump issue 10 in 10 with serialdatatype