From: | Jeremy Finzel <finzelj(at)gmail(dot)com> |
---|---|
To: | greigwise <greigwise(at)comcast(dot)net> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: pglogical in postgres 9.6 |
Date: | 2018-02-14 05:41:10 |
Message-ID: | CAMa1XUg9q92M8cpndpTa3MNDsGLxDW-GjXPi__S1erQi=tR-_w@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Tue, Feb 13, 2018 at 1:46 PM greigwise <greigwise(at)comcast(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Alban Hertroys | 2018-02-14 08:22:11 | Re: Table Partitioning: Sequence jump issue 10 in 10 with serial datatype |
Previous Message | armand pirvu | 2018-02-14 02:58:27 | Re: cursors and function question |