Brendan Jurd wrote:
Why *does* Slony require a bi-directional connection to the subscriber? The data is travelling in one direction only ... what needs to come back the other way?
So the slave can say "yes I got that data you can remove it from my TODO list" ?
This seems to be getting rather messy. I wonder if I might not be better off just writing AFTER triggers on all the tables I'm interested in, which replicate the query to the slave system with psql. It would probably be relatively labour intensive, and increase the burden of administering the schema, but it would also be a much more direct and simple approach.
That sounds like contrib/dbmirror -- Shane Ambler pgSQL@xxxxxxxxxxxxxxxx Get Sheeky @ http://Sheeky.Biz
