|
|
|
|
|
by sugarcode
4954 days ago
|
|
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. |
|