Maybe the postgres supporters can fill this in about Postgres reliability:
http://www.quora.com/How-reliable-is-Postgres-replication
that's one of the biggest issues scaring people away from Postgres.
http://www.quora.com/How-reliable-is-Postgres-replication
that's one of the biggest issues scaring people away from Postgres.
Slony caused us no end of problems (large postgres installations at Last.fm). It's a monumental pain in the ass, it will choke on something, probably when you're trying to make a DDL change, sometimes just at random. Docs/help on trying to figure out what went wrong and how to fix the replication are not easy to find. After you managed to 'fix' it, you will be unsure if the slave is truly in sync. The only way to be confident is to nuke the slave and start over to ensure you have a consistent replica.
That said, I'd still gladly suffer the trials and tribulations of crappy trigger based replication than use MySQL.
I'm looking forward to trying replication in 9.0, it sounds fantastic.
Warm standby is very reliable and easy to admin. The setup is not that easy but not too hard either.