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 E8EFF53338 for ; Tue, 19 Apr 2005 16:29:02 -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 88786-02 for ; Tue, 19 Apr 2005 19:28:53 +0000 (GMT) Received: from bramble.mmrd.com (bramble.mmrd.com [65.217.53.66]) by svr1.postgresql.org (Postfix) with ESMTP id 697D4533BE for ; Tue, 19 Apr 2005 16:28:51 -0300 (ADT) Received: from thorn.mmrd.com (thorn.mmrd.com [172.25.10.100]) by bramble.mmrd.com (8.12.8/8.12.8) with ESMTP id j3JJAuoJ010852; Tue, 19 Apr 2005 15:10:57 -0400 Received: from gnvex001.mmrd.com (gnvex001.mmrd.com [10.225.10.110]) by thorn.mmrd.com (8.11.6/8.11.6) with ESMTP id j3JJSlM04835; Tue, 19 Apr 2005 15:28:48 -0400 Received: from camel.mmrd.com ([172.25.5.213]) by gnvex001.mmrd.com with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.2657.72) id 2LM9FRMX; Tue, 19 Apr 2005 15:28:45 -0400 Subject: Re: FW: Admin Tool to Send Me Email From: Robert Treat To: "Garris, Nicole" Cc: "'pgsql-admin@postgresql.org'" In-Reply-To: References: Content-Type: text/plain Content-Transfer-Encoding: 7bit X-Mailer: Ximian Evolution 1.0.8 Date: 19 Apr 2005 15:28:46 -0400 Message-Id: <1113938927.26133.539.camel@camel> Mime-Version: 1.0 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.032 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200504/272 X-Sequence-Number: 17285 As I see it you have two choices... hack postgresql directly to add in emailing functionality to the elog mechanisms in postgresql or write some type of script/daemon to parse the postgresql logs to look for error messages. A fairly simple script set up to run continuously or via cron could handle the second option, if you want something fancier you could look at http://nagios.sourceforge.net. HTH. Robert Treat On Mon, 2005-04-18 at 17:51, Garris, Nicole wrote: > Yes, I looked at pgMail, thinking I could put a trigger on some system > table(s). PgMail is a function which produces an e-mail. In other words, its > invoked by a SQL select statement. SQL select typically works against a > table. PostgreSQL's log is stored in a file, not in a table. I have no idea > how to parse a log file using a SQL select statement. Also I can't see how > to send the log to a table (instead of/in addition to a file). > > It might be easier to use some Mac OS X utility/ies. > > Anyone have any ideas? > > -----Original Message----- > From: Jaime Casanova [mailto:systemguards@gmail.com] > Sent: Monday, April 18, 2005 12:26 PM > To: Garris, Nicole > Cc: pgsql-admin@postgresql.org > Subject: Re: [ADMIN] Admin Tool to Send Me Email > > On 4/18/05, Garris, Nicole wrote: > > > > > > > > (Previously posted to the PostgreSQL General list, with no responses yet.) > > > > > We have been using PostgreSQL on Mac OS X for about a year now. Ongoing > > monitoring has proven very easy because the DBMS engine is so reliable, > and > > mostly I use phpPgAdmin, an extremely useful tool. However, its worth my > > while to make it even easier. I would like a tool that would send an email > > whenever an error message is generated, such as messages from SQL class 53 > > (53100 disk full, 53200 out of memory, 53300 too many connections), class > 57 > > operator intervention, class 58 system error, and a few others. > > > I don't know if it can be useful for you but there is a project called > pgMail. You need he pl/tclu to run it. > > hope it can help you. > > regards, > Jaime Casanova > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) -- Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL