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
