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 :)
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? |