Skip site navigation (1) Skip section navigation (2)

Re: Replication Options.

From: Chris Browne <cbbrowne(at)acm(dot)org>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Replication Options.
Date: 2004-10-29 20:50:04
Message-ID: 60y8hpntab.fsf@dba2.int.libertyrms.com (view raw or flat)
Thread:
Lists: pgsql-admin
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
> 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.

In response to

Responses

pgsql-admin by date

Next:From: Shawn KovalchickDate: 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"

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group