Andrew Sullivan wrote: > On Fri, Jan 20, 2006 at 05:26:56PM -0600, Jim C. Nasby wrote:
>> Yeah, it would be damn nice if there was a stronger alternative. From >> what I've read I think Slony-II might fit the bill (though I can't >> remember if there's a guarantee that a changeset will exist at least >> somewhere else before COMMIT returns), but I suspect it wouldn't perform >> well over a WAN. > > Well, the idea of slony-2 is that when a COMMIT returns, you are > guartanteed that all then-participating nodes have the data. The big > question is whether slony-2 is even possible, alas. and no, it > certainly won't work over a WAN. Would the new "Two Phase Commit" stuff mentioned in the 8.1 release notes obsolete slony-2? I haven't had a chance to play with it yet, but isn't that what's already there? -- Alan Garrison Cronosys, LLC <http://www.cronosys.com> Phone: 216-221-4600 ext 308 _______________________________________________ Slony1-general mailing list [email protected] http://gborg.postgresql.org/mailman/listinfo/slony1-general
