Thread: Re: Regarding built-in logical replication
On 1/11/18 09:48, PG Doc comments form wrote: > The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/10/static/logical-replication.html > Description: > > I am referring to link > 'https://www.postgresql.org/docs/10/static/logical-replication.html' and it > has been mentioned that 'Replicating between different major versions of > PostgreSQL.' under the section of 'The typical use-cases for logical > replication are:' but I don't think logical replication using > PUBLICATION/SUBSCRIPTION model is possible between different PostgreSQL > versions, which is only possible using pglogical. The documentation is correct. (The only caveat is that there are currently no other versions than 10 that have built-in logical replication, but if there were any, it would work.) -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
This means it would work with version 10 and its later versions. No backward compatibility is possible.
Thanks for resolution.
Ranjan Gajare
On 12-Jan-2018 2:14 AM, "Peter Eisentraut" <peter.eisentraut@2ndquadrant.com> wrote:
On 1/11/18 09:48, PG Doc comments form wrote:
> The following documentation comment has been logged on the website:
>
> Page: https://www.postgresql.org/docs/10/static/logical- replication.html
> Description:
>
> I am referring to link
> 'https://www.postgresql.org/docs/10/static/logical- replication.html' and it
> has been mentioned that 'Replicating between different major versions of
> PostgreSQL.' under the section of 'The typical use-cases for logical
> replication are:' but I don't think logical replication using
> PUBLICATION/SUBSCRIPTION model is possible between different PostgreSQL
> versions, which is only possible using pglogical.
The documentation is correct.
(The only caveat is that there are currently no other versions than 10
that have built-in logical replication, but if there were any, it would
work.)
--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services