On Dec 20, 2006, at 10:13 AM, Norman Yamada wrote:
Yesterday, I dropped one of the slave nodes from the cluster and built postgresql 8.2.0 on it. I then killed all the slon processes, upgraded master and both slave boxes to slony 1.2.2, brought back up the slony cluster and readded the second slave back to the node.
Do you have any indexes on the new replica? Try without any indexes other than the PK and then add them later. Adding/removing indexes is safe to do outside of the slony DDL change mechanism, provided they don't add any more strictness to the data than the master has (ie, no additional unique indexes).
Slony is supposed to disable the indexes but perhaps it is not for some reason.
smime.p7s
Description: S/MIME cryptographic signature
_______________________________________________ Slony1-general mailing list [email protected] http://gborg.postgresql.org/mailman/listinfo/slony1-general
