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). -- Kevin Brown [EMAIL PROTECTED] ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster