X-Original-To: pgsql-novice-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id B77AE3AADB3 for ; Mon, 20 Dec 2004 22:25:38 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 02003-06 for ; Mon, 20 Dec 2004 22:25:26 +0000 (GMT) Received: from web51308.mail.yahoo.com (web51308.mail.yahoo.com [206.190.38.174]) by svr1.postgresql.org (Postfix) with SMTP id A9FED3AADD9 for ; Mon, 20 Dec 2004 22:25:26 +0000 (GMT) Received: (qmail 74534 invoked by uid 60001); 20 Dec 2004 22:25:26 -0000 Comment: DomainKeys? See http://antispam.yahoo.com/domainkeys DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; b=pDK/h2zpVk3GrReGA5yve9qNrgzgKqWztybM3XKmdDm8zxuxvbcbDL62NHQUtQcolWD46fmcH/gTpjyha/SwbLPxM2GQnK675nbzo2y7SzTA++vB+tbG/d2QUfCVicFj7aHY0kAIa5K1oQ3rfeeHqyIj6hXfztbJZKVmWf2kw7A= ; Message-ID: <20041220222526.74532.qmail@web51308.mail.yahoo.com> Received: from [65.218.182.242] by web51308.mail.yahoo.com via HTTP; Mon, 20 Dec 2004 14:25:26 PST Date: Mon, 20 Dec 2004 14:25:26 -0800 (PST) From: sarlav kumar Subject: slony replication To: pgsqlnovice , pgsqlperform MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-1017136136-1103581526=:72359" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.72 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, HTML_20_30, HTML_MESSAGE X-Spam-Level: X-Archive-Number: 200412/195 X-Sequence-Number: 11772 --0-1017136136-1103581526=:72359 Content-Type: text/plain; charset=us-ascii Hi All, 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. 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? 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. Do I need to change any of the other scripts file in the example? Thanks in advance, Saranya --------------------------------- Do you Yahoo!? Send a seasonal email greeting and help others. Do good. --0-1017136136-1103581526=:72359 Content-Type: text/html; charset=us-ascii
Hi All,
 
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.
 
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?
 
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.
 
Do I need to change any of the other scripts file in the example?
 
Thanks in advance,
Saranya
 
 
 
 
 
 


Do you Yahoo!?
Send a seasonal email greeting and help others. Do good. --0-1017136136-1103581526=:72359--