Postgres Pro
Downloads
Home   >   mailing lists

pglogical selective child replication between different partition interval tables - Mailing list pgsql-general

From Durgamahesh Manne
Subject pglogical selective child replication between different partition interval tables
Date
Msg-id CAJCZkoKCryPoaKFeL=8rT0=SmsTzivQKv6C79wVD7=ufAwLF_g@mail.gmail.com
Whole thread Raw
List pgsql-general
Tree view
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 



pgsql-general by date:

Previous
From: Durgamahesh Manne
Date:
Subject: Recommendations on Improving the debezium performance even on medium workload
Next
From: Robert Haas
Date:
Subject: Re: Backward compat issue with v16 around ROLEs