Обсуждение: [ADMIN] Logical Replication

Поиск
Список
Период
Сортировка

[ADMIN] Logical Replication

От
pinker
Дата:
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?

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?






--
Sent from: http://www.postgresql-archive.org/PostgreSQL-admin-f2076596.html


-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Re: [ADMIN] Logical Replication

От
Mark Kirkwood
Дата:
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

Re: [ADMIN] Logical Replication

От
Mark Kirkwood
Дата:
On 10/10/17 12:26, Mark Kirkwood wrote:

>
>
> With respect to 9.4 - you probably need to discuss using pglogical 
> with the EDB guys...

That should really say: ...with the *2nd Quadrant* guys (apologies to 
you all...)!


-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin