On Fri, Nov 19, 2010 at 9:44 PM, Vick Khera <[email protected]> wrote: > On Fri, Nov 19, 2010 at 4:28 AM, Stuart Bishop <[email protected]> > wrote: >>> That suggests to me there being some value to having some sort of "fail >>> if not sufficiently up to date" command. >> >> Pretty much all my canned scripts start by issuing a sync and waiting >> for it. I think it is dangerous to do otherwise. Failing with a >> meaningful error rather than leaving sysadmins staring at a blinking >> prompt would be preferable. > > Nice. What does this look like in the script?
echo 'Waiting for cluster to sync. If this blocks, check for long running transactions and working slon daemons.'; SYNC (i...@master_node); WAIT FOR EVENT (orig...@master_node, wait o...@master_node, confirmed=ALL); echo 'Synced.'; -- Stuart Bishop <[email protected]> http://www.stuartbishop.net/ _______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
