X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 3C370D8A8F for ; Thu, 8 Sep 2005 20:32:08 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 58692-08 for ; Thu, 8 Sep 2005 23:32:03 +0000 (GMT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by svr1.postgresql.org (Postfix) with ESMTP id 936B0D8A75 for ; Thu, 8 Sep 2005 20:32:05 -0300 (ADT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.13.1/8.13.1) with ESMTP id j88NW36a061573 for ; Thu, 8 Sep 2005 23:32:03 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.13.1/8.13.1/Submit) id j88N3vpK056042 for pgsql-admin@postgresql.org; Thu, 8 Sep 2005 23:03:57 GMT (envelope-from news) From: Chris Browne X-Newsgroups: pgsql.admin Subject: Re: triggers Date: Thu, 08 Sep 2005 18:29:01 -0400 Organization: cbbrowne Computing Inc Lines: 28 Message-ID: <60wtlr6vo2.fsf@dba2.int.libertyrms.com> References: Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 X-Complaints-To: usenet@news.hub.org User-Agent: Gnus/5.1007 (Gnus v5.10.7) XEmacs/21.4.17 (Jumbo Shrimp, linux) Cancel-Lock: sha1:WNO5miGduKweg+eGBxvBp/ihdf0= To: pgsql-admin@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=-2.477 required=5 tests=[ALL_TRUSTED=-2.82, AWL=0.343] X-Spam-Level: X-Archive-Number: 200509/91 X-Sequence-Number: 18828 kailash.vyas@gmail.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."