hi all,
we are about to migrate our entire platform to postgres. But we have some trouble in translate the actual replication system.

in details

HOST1 (master for T1 and T2)
TABLE1 (populated)
TABLE2 (populated)
TABLE3 (empty)

HOST2 (slave for T1 and T2, master for T3)
TABLE1 (populated, replicated from HOST1)
TABLE2 (populated, replicated from HOST1)
TABLE3 (populated)

HOST3 (slave)
TABLE1 (populated, replicated from HOST1)
TABLE2 (populated, replicated from HOST1)
TABLE3 (populated, replicated from HOST2)


so, I haven't found yet a possible architecture, or a 3rd party plugin, for maintain this replication schema.

We could set triggers, stored and some java class for replicate data from H2T3 to H3T3, but we would possibly avoid this approach.

Another scenario considered is create 2 different databases, but we want to avoid also this solutions, we have joins between T3 and the other tables, also for maintenance purpose one DBMS is much better than two.

any suggestion?
thx in advance
stefano