Maly Mohsem Ahmed
Maly Mohsem Ahmed

Reputation: 41

Replication for partitioned table in PostgreSQL

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?

Upvotes: 1

Views: 428

Answers (1)

Josh
Josh

Reputation: 377

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.

Upvotes: 2

Related Questions