3 ms·
What struck me instantly was the use of Slony. I haven't listened to the whole thing yet but I am interested in their justification. Perhaps they just haven't m
by hahainternet 14y ago
What struck me instantly was the use of Slony. I haven't listened to the whole thing yet but I am interested in their justification. Perhaps they just haven't moved to 9.2 yet.
- d0ugal 14y agoI don't think they could move to 9.2 in 2010 ;)
- sugarcode 14y agoslony 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.