pglogical selective child replication between different partition interval tables

Started by Durgamahesh Manneover 1 year ago1 messagesgeneral
Jump to latest
#1Durgamahesh Manne
maheshpostgres9@gmail.com

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