Thread: pglogical selective child replication between different partition interval tables

pglogical selective child replication between different partition interval tables

From
Durgamahesh Manne
Date:
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