We have an in-house app, currently using MySQL, for which failover would be nice. Nothing fancy, just two instances running in case the primary goes south.

Does anyone have experience with doing something like this under either pgSQL or MySQL?