pglogical selective child replication between different partition interval tables

From: Durgamahesh Manne <maheshpostgres9(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org, pgsql-in-general(at)postgresql(dot)org, Greg Sabino Mullane <htamfids(at)gmail(dot)com>
Subject: pglogical selective child replication between different partition interval tables
Date: 2024-09-12 20:04:40
Message-ID: CAJCZkoKCryPoaKFeL=8rT0=SmsTzivQKv6C79wVD7=ufAwLF_g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-in-general

Hi Respected Team
Here source side tables are created with 7 days partition interval here we
have data within them

changelog_event_p20240830
changelog_event_p20240906

Target side tables are created with 3 days partition interval
Structure of tables at both side is same

Would it be possible to replicate selective child table
(changelog_event_p20240906) to target with logical replication or pglogical

create publication with where clause does work in this scenario?

Regards.
Durga Mahesh

Browse pgsql-general by date

  From Date Subject
Next Message Robert Haas 2024-09-12 21:11:26 Re: Backward compat issue with v16 around ROLEs
Previous Message Durgamahesh Manne 2024-09-12 19:51:55 Recommendations on Improving the debezium performance even on medium workload

Browse pgsql-in-general by date

  From Date Subject
Previous Message Durgamahesh Manne 2024-09-12 19:51:55 Recommendations on Improving the debezium performance even on medium workload