Dawid Kuroczko wrote:
Slony is good as long as there are no DDLs issued. And its easy to
shoot oneself in the foot if one is not careful (some time ago I have
lost all the triggers while upgrading from 8.1 to 8.2; it was my fault
since I did pg_dump -s on a slave database, not on the master...).
It can also be a very time consuming process. It often also involves
having to juggle resources around, find extra disk space floating around
somewhere to build extra replicas, or abandon your fail over target for
a period of time while upgrade that.
BTW, the trigger issue goes away with 8.3 and Slony 2.0.
Brad.
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
