On Mon, September 1, 2008 4:09 am, Craig Ringer wrote:
> Right now, PostgreSQL has network-based master-to-slave(s) clustering
> using Slony that permits slaves to operate online read-only as reporting
> servers etc. It also covers failover with the use of an external
> heartbeat/STONITH setup. However, it's not completely transparent to the
> application and it's not seen as "part of postgresql".
>
> There are some other options that I'm largely unfamiliar with out there,
> but right now it seems that Slony is the way to go with Pg.
...and Skytools (as used by Skype, I believe, which is now Open Source),
which is far simpler to use and in my experience far more reliable.
Cheers
Henry
