From: | Chris Browne <cbbrowne(at)acm(dot)org> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: triggers |
Date: | 2005-09-08 22:29:01 |
Message-ID: | 60wtlr6vo2.fsf@dba2.int.libertyrms.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
kailash(dot)vyas(at)gmail(dot)com (Kailash Vyas) writes:
> hi
> I have a query regarding triggers.
> On INSERT, UPDATE, DELETE I want to fire a trigger to relect it to another database on postgres sever.
> how can I do this operation.
> Thanks in advance,
> Kailash Vyas
If you wish the trigger to result in some action taking place on
another database, then there are two major methodologies available:
1. The trigger could RAISE an event.
A LISTENing daemon would see that event, and do something in the
other database.
2. The trigger could write data into a replicated table.
The replication system (possibly Slony-I?) would then copy
the replicable data to the other database.
--
"cbbrowne","@","cbbrowne.com"
http://cbbrowne.com/info/slony.html
Rules of the Evil Overlord #52. "I will hire a team of board-certified
architects and surveyors to examine my castle and inform me of any
secret passages and abandoned tunnels that I might not know about."
<http://www.eviloverlord.com/>
From | Date | Subject | |
---|---|---|---|
Next Message | adey | 2005-09-09 01:13:32 | Stats turned on but not being updated |
Previous Message | Stephan Szabo | 2005-09-08 22:01:23 | Re: triggers |