Pallav Kalva wrote:

> 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 Slony Replication for Postgres 7.4/8.0 ?

It certainly is possible.

You could do this two ways:

1.  Create two Slony-I clusters, "canada" and "usa", which each have one 
replication set for the single table that each wants replicated.

2.  Create one Slony-I cluster, and then have two replication sets, 1 
and 2, one set handling the "Canada" table, and the other set handling 
the "USA" table.

Approach #2 is probably simpler to deal with...