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

Re: slony replication

From: Christopher Browne <cbbrowne(at)ca(dot)afilias(dot)info>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: slony replication
Date: 2004-12-20 23:31:04
Message-ID: 60r7lkbl8n.fsf@dba2.int.libertyrms.com (view raw or flat)
Thread:
Lists: pgsql-novicepgsql-performance
sarlavk(at)yahoo(dot)com (sarlav kumar) writes:
> I installed slony1.0.5 and tried the example replication of pgbench
> database. That seemed to work. Now I need to replicate a DB running
> on a different server. slony1.0.5 is installed on the Fedora core 3
> machine where Postgres 7.4.6 is installed. I have to replicate the
> 'test' database installed on a different machine using Postgres
> 7.3.2.

Slony-I does not support versions of PostgreSQL earlier than 7.3.3.
As 7.3.2 is earlier than 7.3.3, I wouldn't expect that to work.

> In the instructions to replicate the pgbench example, there is
> script file to create the initial configuration for the master-slave
> setup of the pgbench database. Is this the script file that has to
> be modified accordingly, to replicate my 'test' DB. And ofcourse,
> the shell variables have to be changed to indicate the correct
> location of the master and slave DBs. Am I right?

Yes, that would be right.

> Also, in the script, the following lines are used to create sets of tables:
>
> # Slony-I organizes tables into sets.  The smallest unit a node can
>     # subscribe is a set.  The following commands create one set containing
>     # all 4 pgbench tables.  The master or origin of the set is node 1.
> #--
> create set (id=1, origin=1, comment='All pgbench tables');
> set add table (set id=1, origin=1, id=1, fully qualified name = 'public.accounts', comment='accounts table');
> set add table (set id=1, origin=1, id=2, fully qualified name = 'public.branches', comment='branches table');
> set add table (set id=1, origin=1, id=3, fully qualified name = 'public.tellers', comment='tellers table');
> set add table (set id=1, origin=1, id=4, fully qualified name = 'public.history', comment='history table', key =
> serial);
> #--
>
> Can this be skipped? I have over 200 tables, and I am not sure if I
> have to list each of them in the "set add table" part of the scripts
> file.

No, you cannot "skip" this.  You _must_ submit slonik requests to add
each and every table that you wish to replicate to the replication
set.

If there are 220 tables, you'll need something rather close to 220
"set add table" requests.

> Do I need to change any of the other scripts file in the example?

Maybe, depending on what you're trying to do.
-- 
"cbbrowne","@","ca.afilias.info"
<http://linuxdatabases.info/info/slony.html>
Christopher Browne
(416) 673-4124 (land)

In response to

pgsql-novice by date

Next:From: Steve CrawfordDate: 2004-12-20 23:53:00
Subject: Re: SQUID Log in PostgreSQL
Previous:From: sarlav kumarDate: 2004-12-20 22:25:26
Subject: slony replication

pgsql-performance by date

Next:From: kondo_yoDate: 2004-12-21 01:42:10
Subject: Question of performance of version 8
Previous:From: Alexander BorkowskiDate: 2004-12-20 23:09:06
Subject: Re: PG Logging is Slow

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