pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Robert Treat <xzilla@users.sourceforge.net>
To: Garris, Nicole <Nicole.Garris@dof.ca.gov>
Cc: 'pgsql-admin@postgresql.org' <pgsql-admin@postgresql.org>
Subject: Re: FW: Admin Tool to Send Me Email
Date: 19 Apr 2005 15:28:46 -0400
Message-ID: <1113938927.26133.539.camel@camel> (raw)
In-Reply-To: <DA1D6951A4720F4FBC5BF398E4D5B122280CC4@dofmail.DOF.FINANCE>
References: <DA1D6951A4720F4FBC5BF398E4D5B122280CC4@dofmail.DOF.FINANCE>

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 <Nicole.Garris@dof.ca.gov> 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




view thread (4+ messages)

Message-ID: <1113938927.26133.539.camel@camel>
Permalink:  ../1113938927.26133.539.camel@camel/
Also on:    postgresql.org/message-id/1113938927.26133.539.camel@camel

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: xzilla@users.sourceforge.net, Nicole.Garris@dof.ca.gov
  Subject: Re: FW: Admin Tool to Send Me Email
  In-Reply-To: <1113938927.26133.539.camel@camel>
  References: <DA1D6951A4720F4FBC5BF398E4D5B122280CC4@dofmail.DOF.FINANCE> <1113938927.26133.539.camel@camel>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox