pkalva(at)deg(dot)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
> 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];;
A VAX is virtually a computer, but not quite.
In response to
pgsql-admin by date
|Next:||From: Shawn Kovalchick||Date: 2004-10-29 23:44:55|
|Subject: Problem connecting to localhost in 7.4.2|
|Previous:||From: Vishal Kashyap @ [Sai Hertz And Control Systems]||Date: 2004-10-29 20:15:50|
|Subject: Re: psql won't "createdb"|