Replication for partitioned table in PostgreSQL

Question

I want to replicate a partitioned table in PostgreSQL using SymmetricDS. Do I have to configure sym_trigger for individual partitioning table or just the partitioned table?

What have you tried so far? – Boris Pavlović May 18 '22 at 08:17 — Boris Pavlović, May 18 '22 at 08:17

score 2 · Answer 1 · answered May 18 '22 at 17:18

2

You should be able to setup a SymmetricDS trigger just like any other table configured for replication. The PostgreSQL database will take care of what triggers are cloned/created on each partition.

answered May 18 '22 at 17:18

Josh

357
1
4

yes. that approach works for me. Thanks – Maly Mohsem Ahmed May 19 '22 at 04:04

Replication for partitioned table in PostgreSQL

1 Answers1