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

FW: Admin Tool to Send Me Email

From: "Garris, Nicole" <Nicole(dot)Garris(at)dof(dot)ca(dot)gov>
To: "'pgsql-admin(at)postgresql(dot)org'" <pgsql-admin(at)postgresql(dot)org>
Subject: FW: Admin Tool to Send Me Email
Date: 2005-04-18 21:51:16
Message-ID: DA1D6951A4720F4FBC5BF398E4D5B122280CC4@dofmail.DOF.FINANCE (view raw or flat)
Thread:
Lists: 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(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

Responses

pgsql-admin by date

Next:From: Bruce MomjianDate: 2005-04-18 21:55:57
Subject: Re: Latest pg_autovacuum script
Previous:From: Tom LaneDate: 2005-04-18 21:39:11
Subject: Re: brute force attacking the password

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