On: Disqus: Scaling the World’s Largest Django Applica...

[sugarcode]

slony offers some compelling advantages over streaming replication - even on new databases we setup, we still like slony for several reasons:

* Version upgrades (streaming replication requires the same PG version between master/slave, slony does not)

* Logical replication gives us finer-grained control over how data is replicated across the cluster

* Ability to create additional indexes on slaves

slony isn't perfect and it has caused us some headaches, but its flexibility makes it our go-to replication tool for postgres.