On Sun, Jan 18, 2009 at 07:24:31PM +0200, Hannu Krosing wrote:
> > Thanks David. I had thought of some general solutions like you
> > mentioned, just wondering if it could be done with slony out of the
> > box. Thanks again.
> 
> Check out https://developer.skype.com/SkypeGarage/DbProjects/SkyTools
> (and especially it's pgQ part), which uses similar mechanics to Slony
> but allows finer control of what is done .

You could also do this with Slony by running a STORE TRIGGER that, on
the replica, had a DO INSTEAD NOTHING effect for UPDATEs and DELETEs.
It's going to be tricky, though, if your UPDATEs change things that
will later cause a violation of a unique index on the replica.  So you
may need to tune the indexes as well.

A

-- 
Andrew Sullivan
ajs at crankycanuck.ca