3 ms·
Ugh, slony is awful. You use Slony when you have to do a live migration from one version to another (say 9.3 to 9.4) without any downtime. WAL replication is
by bmurphy1976 12y ago
Ugh, slony is awful. You use Slony when you have to do a live migration from one version to another (say 9.3 to 9.4) without any downtime. WAL replication is the way to go most of the time. I've used Londiste, it's better than Slony if you need partial replication, but still messy to use compared to WAL.
Personally I haven't used any of the others (i.e. Bucardo).
- akurilin 12y agoWould you be so kind as to provide context on why WAL replication is superior to logical replication? I'm very interested in learning more about it. Also, what specifically did you hate about Slony? Any resources you'd recommend on this?
- rpedela 12y agoWAL replication is currently the official and best supported mechanism for replication. If WAL replication does not suite your particular use case, then that is when to start looking at Slony, Bucardo, etc.