Re: Replication Options.

pkalva@deg.cc (Pallav Kalva) writes:
>     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 ?

This scenario would be supported by Slony-I; there are several ways to
accomplish it, probably the easiest being thus...

- Create two nodes, 1 and 2

- Create two replication sets - #1 and #2.

  - Set 1 has origin of node 1
  - Set 2 has origin of node 2

  - Add tablea to set 1
  - Add tableb to set 2

  - Subscribe node 2 to set 1
  - Subscribe node 1 to set 2

Either node can run PG 7.4 or 8.0...
--
let name="cbbrowne" and tld="cbbrowne.com" in String.concat "@" [name;tld];;
http://slony.info
A VAX is virtually a computer, but not quite.