Re: 2-phase commit

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 kevin(at)sysexperts(dot)com