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@xxxxxxxxx] Sent: Monday, April 18, 2005 12:26 PM To: Garris, Nicole Cc: pgsql-admin@xxxxxxxxxxxxxx Subject: Re: [ADMIN] Admin Tool to Send Me Email On 4/18/05, Garris, Nicole <Nicole.Garris@xxxxxxxxxx> 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
