I have set up and run both slony and mammoth-replicator in production. It is not a trivial task.

The big problem I've encountered is that the database to be replicated must have defined primary keys. Far too few developers understand what is meant by referential integrity.