On Tue, Jan 23, 2007 at 05:23:34PM -0500, Mark Stosberg wrote:
> ... but that uses the very ancient "Pg.pm" and not DBI/DBD::Pg.

Pg.pm is in fact supported and maintained.  For postgres-only work, I
think it's much nicer than DBI, because you don't have the
abstraction layer the benefits of which you're going to throw away by
tying tightly to the database engine anyway.

> I'm also curious if anyone is using Nagios' event handling as part of
> failover-- using it to notice that a slave is down, and then make a
> pro-active change to handle failover.

I'd be leery of this, because Nagios's event handling is slightly
underdetermined in when any event will in fact run.  It's adaptive,
which means if you have a lot of other things happening, your job
might not run exactly on time.

A

-- 
Andrew Sullivan  | ajs at crankycanuck.ca
This work was visionary and imaginative, and goes to show that visionary
and imaginative work need not end up well. 
		--Dennis Ritchie