Re: Request for replication advice

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@007Marketing.com

Get Sheeky @ http://Sheeky.Biz