Обсуждение: [GENERAL] Logical replication
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? -- Adrian Klaver adrian.klaver@aklaver.com
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: postgres=# CREATE SUBSCRIPTION pgsql10sub CONNECTION 'dbname=replication_test host=localhost user=postgres port=5412' PUBLICATION pgsql94; ERROR: could not receive list of replicated tables from the publisher: ERROR: syntax error 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. 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 -- Adrian Klaver adrian.klaver@aklaver.com
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. pglogical will continue to exist, so you can also keep using it if you already have it. -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
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.klaver@aklaver.com
On 05/01/2017 09:34 AM, Adrian Klaver wrote: > 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? The present as of now: https://www.postgresql.org/message-id/CAH%2BGA0o5B89eDJjoKO-yN%3DXQEsC%2BpA2n9LuQPun0EAz9fVcUEA%40mail.gmail.com > > > > -- Adrian Klaver adrian.klaver@aklaver.com