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