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

Reply via email to