Triggers on replicated (BDR) data

From: Daniel Smedegaard Buus <danielbuus(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Triggers on replicated (BDR) data
Date: 2015-08-28 07:04:23
Message-ID: CAHnuAezuA_F8qzQPBzV3HD8T1ZkkPxZ58=+0f+Mzg8Y1b_hkxg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hey there :)

These days are my first ones with postgres, and I must say I'm impressed!

I'm setting up a BDR group and I was trying to use triggers to
automatically configure the HBA on existing nodes when a new node joins or
an old one leaves. Basically, its a triggered perl function calling an
external shell script.

When a node joins, the trigger works great on the node that the newcomer
talks to, but on other nodes, the trigger ("AFTER INSERT ON bdr.bdr_nodes")
is never activated.

Assuming that the data in bdr.bdr_nodes is replicated rather than INSERTed,
I guess this behavior sort of makes sense... But I'm hoping there's some
way to either change the behavior, or perhaps something else that I can
attach a trigger to?

Anyone ideas?

Cheers,
Daniel :)

Browse pgsql-novice by date

  From Date Subject
Next Message Daniel Smedegaard Buus 2015-08-31 08:54:58 Triggers on bdr.bdr_nodes?
Previous Message s d 2015-08-24 11:38:40 Re: Truncating table in PSQL reclaims hard disk?