I'm trying to migrate a node for the second time, and no luck. Last time I tried it, it just got stuck, and due to lack of time, I didn't investigate.
This time I watched -- it got stuck again, doing some sort of huge SELECT statement. I was under the impression that migrating a node was a fairly simple operation that should happen in a short time (less than a minute?) even for large databases. I waited 10 minutes, during which the entire system was completely locked up (no other process could access the database), and our web site was offline. I finally had to kill all of the slon daemons and kill Postgres to get our site back on the air, then run the node-unlock command to get Slony back in shape. This system appears to otherwise be working well. I can insert, update and delete records, and they're copied to the slave node immediately. What's up? Am I just too impatient? Thanks, Craig _______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
