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@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 > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@xxxxxxxxxxxxxx) -- Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
