Altering or dropping tables which are in logical replication is not a good idea if the changes are not uniform across a TRAKTOR cluster. So, TABLEs in a replicaset are now protected against DROP TABLE and ALTER TABLE by default using PostgreSQL event triggers.
Thursday, November 16, 2023
Friday, November 10, 2023
TRAKTOR, a native trigger function for the fearless
TRAKTOR uses a trigger to break replication cycles on PostgreSQL servers < 16.x. By default, the trigger function tf_break_cycle() is implemented in pl/pgSQL. But now, if you are fearless, there is a native replacement written in C available for pedal-to-the-metal performance.
Labels:
C,
multimaster,
native,
performance,
postgresql,
replication,
TRAKTOR,
trigger
Subscribe to:
Posts (Atom)