Re: Logical replication

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Logical replication
Date: 2017-05-01 16:34:48
Message-ID: 497b0b32-5e0b-c0f6-76a5-7c79e6b3730d@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 05/01/2017 09:25 AM, Peter Eisentraut wrote:
> On 5/1/17 10:32, Adrian Klaver wrote:
>> On 04/30/2017 09:07 AM, Adrian Klaver wrote:
>>> I have started looking at the logical replication feature in Postgres
>>> 10. One thing I have no been able to determine is the interoperability
>>> between it and pglogical(www.2ndquadrant.com/en/resources/pglogical/). I
>>> know the one is derived from the other, what I can not find is whether a
>>> Postgres 9.4 instance with the pglogical extension installed can
>>> communicate with a Postgres 10 instance using the built in code?
>
>> Some testing says the answer is no:
>
> correct
>
>> If I am correct, this means from 9.4 <--> 10 and points in between you
>> would need to use the pglogical extension on both ends.
>
> correct
>
>> Going from 10
>> --> you could use the builtin logical replication. This leads to another
>> question. Is is possible to use both at the same time?:
>>
>> 9.4 ---> 10(instance 1) ---> 10(instance 2)
>> pglogical pglogical
>> builtin builtin
>
> That is possible.

Thanks for the information.

>
> pglogical will continue to exist, so you can also keep using it if you
> already have it.
>

I tried building the pglogical extension against Postgres 10 and it
seems that is not possible yet, which tracks the information on the
pglogical page:

https://www.2ndquadrant.com/en/resources/pglogical/pglogical-installation-instructions/

I went to the GitHub repo:

https://github.com/2ndQuadrant/pglogical

and did not see anything that looks ready for Postgres 10.

Am I missing something or is this something for the future?

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thomas Güttler 2017-05-01 20:02:15 Re: Can PG replace redis, amqp, s3 in the future?
Previous Message Peter Eisentraut 2017-05-01 16:25:08 Re: Logical replication