X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 7A3803A469E for ; Thu, 20 Jan 2005 13:12:17 +0000 (GMT) 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 92897-10 for ; Thu, 20 Jan 2005 13:12:10 +0000 (GMT) Received: from mail.gmx.net (mail.gmx.de [213.165.64.20]) by svr1.postgresql.org (Postfix) with SMTP id 5E9B93A459A for ; Thu, 20 Jan 2005 13:12:11 +0000 (GMT) Received: (qmail invoked by alias); 20 Jan 2005 13:12:07 -0000 Received: from dsl-082-082-230-110.arcor-ip.net (EHLO colt.pezone.net) (82.82.230.110) by mail.gmx.net (mp004) with SMTP; 20 Jan 2005 14:12:07 +0100 X-Authenticated: #495269 From: Peter Eisentraut To: "Joost Kraaijeveld" Subject: Re: Run external program on a trigger? Date: Thu, 20 Jan 2005 14:12:01 +0100 User-Agent: KMail/1.7.1 Cc: "Pgsql-Admin (E-mail)" References: In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200501201412.01494.peter_e@gmx.net> X-Y-GMX-Trusted: 0 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.05 tagged_above=0 required=5 tests=FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200501/216 X-Sequence-Number: 16075 Joost Kraaijeveld wrote: > Is it possible to run an arbitrary external program on my Linux > machine if a trigger fires? Sure, just have the trigger procedure call the external program. The untrusted languages can do that, or if you want to go barebones, try PL/sh (http://developer.postgresql.org/~petere/pgplsh/)/ -- Peter Eisentraut http://developer.postgresql.org/~petere/