From: Chris Browne <cbbrowne@acm.org>
To: pgsql-admin@postgresql.org
Subject: Re: Replication Options.
Date: Fri, 29 Oct 2004 16:50:04 -0400
Message-ID: <60y8hpntab.fsf@dba2.int.libertyrms.com> (raw)
References: <418261A5.5060006@deg.cc>
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: cbbrowne@acm.org
Subject: Re: Replication Options.
In-Reply-To: <60y8hpntab.fsf@dba2.int.libertyrms.com>
References: <418261A5.5060006@deg.cc> <60y8hpntab.fsf@dba2.int.libertyrms.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox