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

[Joe Conway]

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

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend