Andrew Sullivan ajs at crankycanuck.ca
Fri Jun 1 04:08:37 PDT 2007
On Fri, Jun 01, 2007 at 01:41:44PM +0400, Dmitry Koterov wrote:
> Seems when I use EXECUTE
> SCRIPT<http://slony.info/documentation/stmtddlscript.html>and slonik
> reports PGRES_TUPLES_OK updates may NOT be finished yet on all
> slaves.

Right.  If that weren't the case, we wouldn't have WAIT FOR EVENT.

> 1. THE MAIN question: is it possible to ask slonik to wait untill all scheme
> changes were propogated to all slaves after a slonik call?

See above, and http://slony.info/documentation/stmtwaitevent.html

> 2. If slonik updates slaves not immediately, but via event creation, why
> does it still need to know an information about ALL database hosts, not only
> about the master database? I have to enumerate all slave hosts in slonik
> calls:

You need this information for some cases, and unfortunately that just
means that we require it for all cases.  Slonik is indeed a little
clunky that way.  It wasn't really intended to be the last word in
administration interface for Slony-I.

A

-- 
Andrew Sullivan  | ajs at crankycanuck.ca
This work was visionary and imaginative, and goes to show that visionary
and imaginative work need not end up well. 
		--Dennis Ritchie


More information about the Slony1-general mailing list