Kevin Brown wrote: > Bruce Momjian wrote: > > Marc G. Fournier wrote: > > > > > > > > > On Sat, 27 Sep 2003, Bruce Momjian wrote: > > > > > > > I have been thinking it might be time to start allowing external > > > > programs to be called when certain events occur that require > > > > administrative attention --- this would be a good case for that. > > > > Administrators could configure shell scripts to be run when the network > > > > connection fails or servers drop off the network, alerting them to the > > > > problem. Throwing things into the server logs isn't _active_ enough. > > > > > > Actually, apparently you can do this now ... there is apparently a "mail > > > module" for PostgreSQL that you can use to have the database send email's > > > out ... > > > > The only part that needs to be added is the ability to call an external > > program when some even occurs, like a database write failure. > > Actually, all that's really necessary is the ability to call a stored > procedure when some event occurs. The stored procedure can take it from > there, and since it can be written in C it can do anything the postgres > user can do (for good or for ill, of course).
But the postmaster doesn't connect to any database, and in a serious failure, might not be able to start one. -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
