From: Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
To: pgsql-admin@postgresql.org
Subject: Re: Logical Replication
Date: Tue, 10 Oct 2017 12:26:32 +1300
Message-ID: <afb6113f-cb1c-001b-809f-e42532716017@catalyst.net.nz> (raw)
In-Reply-To: <1507567385371-0.post@n3.nabble.com>
References: <1507567385371-0.post@n3.nabble.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
On 10/10/17 05:43, pinker wrote:
> Hi,
> I'm just trying out new feature - logical replication. It works great
> between 10 and 10, but I would like to try between different major version.
> Documentation says it's possible : /Replicating between different major
> versions of PostgreSQL/, but I cannot find any post with setup examples
> (yes, I did google search :).
> Do you know maybe where can I find it?
> If I would like to replicate 9.4 to 10 it means I need to install pglogical?
> or it's happening through fdw for instance?
I think the docs mean that logical replication works between different
versions of Postgres - provided they both have the logical replication
code! So you will be able to run it between version 10 and 11 for instance.
With respect to 9.4 - you probably need to discuss using pglogical with
the EDB guys (ISTM that it is slightly different from the logical
replication code in version 10).
>
> Another thing that puzzles me:
> I have created 2 identical publications what resulted in the data
> duplication. Is it intended to work this way? or maybe some checks will
> appear later on?
>
>
Probably worth raising this as a bug.
regards
Mark
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: mark.kirkwood@catalyst.net.nz
Subject: Re: Logical Replication
In-Reply-To: <afb6113f-cb1c-001b-809f-e42532716017@catalyst.net.nz>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox