Re: [GENERAL] Proposal for a cascaded master-slave replication system

Jan Wieck wrote:
> http://developer.postgresql.org/~wieck/slony1.html

Very interesting read. Nice work!

> We want to build this system as a community project. The plan was from
> the beginning to release the product under the BSD license. And we think
> it is best to start it as such and to ask for suggestions during the
> design phase already.

I couldn't quite tell from the design doc -- do you intend to support
conditional replication at a row level?

I'm also curious, with cascaded replication, how do you handle the case
where a second level slave has a transaction failure for some reason, i.e.:

             M
            / \
           /   \
         Sa     Sb
        /  \   /  \
       Sc  Sd Se  Sf

What happens if data is successfully replicated to Sa, Sb, Sc, and Sd,
and then an exception/rollback occurs on Se?

Joe