Hi ,
I need to implement the following the replication scenario in postgres database. Here are the details of what we are looking to implement.
Lets say I have 2 nodes Node1(US) and Node2(Canada),
Node1: tableA , tableB Node2: tableB , tableA
tableA in Node1 is the master and it should replicate only to slave tableA in Node2
tableB in Node2 is the master and it should replicate only to slave tableB in Node1
Can this be possible with any of the replication models available for Postgres 7.4/8.0 ?
Thanks! Pallav
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster