pglogical3 : support

Started by Perumal Raj7 months ago3 messages
#1Perumal Raj
perucinci@gmail.com

Hi Team,

I am looking to upgrade pg17 with near zero downtime using logical
replication(master <-> master) . The current pglogical2 ( open) has some
limitation with 'REPLICA IDENTITY FULL' tables.

Do we have any plan to make pglogical3 open source in near future? 😊 or
is there better way to achieve the same using open source packages ?

My cluster setup:
Source is less than 14 , Heavily used postgis extension.
Multiple Physical replication.
And running with many 'Replica identity Full ' table configuration.

Thanks,

#2Amit Kapila
amit.kapila16@gmail.com
In reply to: Perumal Raj (#1)
Re: pglogical3 : support

On Sat, Jun 14, 2025 at 2:05 PM Perumal Raj <perucinci@gmail.com> wrote:

Hi Team,

I am looking to upgrade pg17 with near zero downtime using logical replication(master <-> master) . The current pglogical2 ( open) has some limitation with 'REPLICA IDENTITY FULL' tables.

Do we have any plan to make pglogical3 open source in near future? 😊 or is there better way to achieve the same using open source packages ?

The PostgreSQL community doesn't support pglogical. You can contact
pglogical community for your questions on the same.

--
With Regards,
Amit Kapila.

#3Bruce Momjian
bruce@momjian.us
In reply to: Amit Kapila (#2)
Re: pglogical3 : support

On Mon, Jun 16, 2025 at 02:50:18PM +0530, Amit Kapila wrote:

On Sat, Jun 14, 2025 at 2:05 PM Perumal Raj <perucinci@gmail.com> wrote:

Hi Team,

I am looking to upgrade pg17 with near zero downtime using logical replication(master <-> master) . The current pglogical2 ( open) has some limitation with 'REPLICA IDENTITY FULL' tables.

Do we have any plan to make pglogical3 open source in near future? 😊 or is there better way to achieve the same using open source packages ?

The PostgreSQL community doesn't support pglogical. You can contact
pglogical community for your questions on the same.

FYI, I think the community is here:

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

--
Bruce Momjian <bruce@momjian.us> https://momjian.us
EDB https://enterprisedb.com

Do not let urgent matters crowd out time for investment in the future.