Re: pglogical in postgres 9.6

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

In response to

Browse pgsql-general by date

  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