| 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
| 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 |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Durgamahesh Manne | 2024-09-15 11:44:58 | Generate the valid snapshot during creation of for the purpose of taking pg_dump with --snapshot option |
| Previous Message | Durgamahesh Manne | 2024-09-12 19:51:55 | Recommendations on Improving the debezium performance even on medium workload |