pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Admin Tool to Send Me Email
4+ messages / 3 participants
[nested] [flat]

* Admin Tool to Send Me Email
@ 2005-04-18 18:14  Garris, Nicole <Nicole.Garris@dof.ca.gov>
  0 siblings, 1 reply; 4+ messages in thread

From: Garris, Nicole @ 2005-04-18 18:14 UTC (permalink / raw)
  To: pgsql-admin

(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 looked for such a free tool on pgFoundry, Gborg, and postgresql.org's
Downloads page (and also searched the PostgreSQL mailing list archives) but
didn't see anything like it. If you know of one, I would really appreciate
it if you could provide the web site. Thank you!

 

^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Admin Tool to Send Me Email
@ 2005-04-18 19:25  Jaime Casanova <systemguards@gmail.com>
  parent: Garris, Nicole <Nicole.Garris@dof.ca.gov>
  0 siblings, 0 replies; 4+ messages in thread

From: Jaime Casanova @ 2005-04-18 19:25 UTC (permalink / raw)
  To: Garris, Nicole <Nicole.Garris@dof.ca.gov>; +Cc: pgsql-admin

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



^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* FW: Admin Tool to Send Me Email
@ 2005-04-18 21:51  Garris, Nicole <Nicole.Garris@dof.ca.gov>
  0 siblings, 1 reply; 4+ messages in thread

From: Garris, Nicole @ 2005-04-18 21:51 UTC (permalink / raw)
  To: pgsql-admin

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



^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: FW: Admin Tool to Send Me Email
@ 2005-04-19 19:28  Robert Treat <xzilla@users.sourceforge.net>
  parent: Garris, Nicole <Nicole.Garris@dof.ca.gov>
  0 siblings, 0 replies; 4+ messages in thread

From: Robert Treat @ 2005-04-19 19:28 UTC (permalink / raw)
  To: Garris, Nicole <Nicole.Garris@dof.ca.gov>; +Cc: 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 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




^ permalink  raw  reply  [nested|flat] 4+ messages in thread


end of thread, other threads:[~2005-04-19 19:28 UTC | newest]

Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-04-18 18:14 Admin Tool to Send Me Email Garris, Nicole <Nicole.Garris@dof.ca.gov>
2005-04-18 19:25 ` Jaime Casanova <systemguards@gmail.com>
2005-04-18 21:51 FW: Admin Tool to Send Me Email Garris, Nicole <Nicole.Garris@dof.ca.gov>
2005-04-19 19:28 ` Robert Treat <xzilla@users.sourceforge.net>

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