Skip site navigation (1) Skip section navigation (2)

Re: FW: Admin Tool to Send Me Email

From: Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
To: "Garris, Nicole" <Nicole(dot)Garris(at)dof(dot)ca(dot)gov>
Cc: "'pgsql-admin(at)postgresql(dot)org'" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: FW: Admin Tool to Send Me Email
Date: 2005-04-19 19:28:46
Message-ID: 1113938927.26133.539.camel@camel (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
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 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(at)gmail(dot)com] 
> Sent: Monday, April 18, 2005 12:26 PM
> To: Garris, Nicole
> Cc: pgsql-admin(at)postgresql(dot)org
> Subject: Re: [ADMIN] Admin Tool to Send Me Email
> On 4/18/05, Garris, Nicole <Nicole(dot)Garris(at)dof(dot)ca(dot)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(at)postgresql(dot)org)

Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL

In response to

pgsql-admin by date

Next:From: Zuoxin.WangDate: 2005-04-19 20:27:09
Previous:From: Bobb ShieldsDate: 2005-04-19 18:11:47
Subject: Troubleshooting Postgres7.4

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group