Mon Jan 17 17:58:00 PST 2005
- Previous message: [Slony1-general] 2 host slonik config question
- Next message: [Slony1-general] subscriber set error - help needed
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Can anyone explain what this error means: ./replicate_subscribe.sh <stdin>:10: PGRES_FATAL_ERROR select "_bpixreplicate".subscribeSet(1, 1, 2, 'f'); - ERROR: Slony-I: set 1 not found Help?! John Sidney-Woollett Here's the subscribe script that is causing the error when it is executed. ======================================= slonik script to subscribe to set ======================================= #!/bin/bash /usr/local/pgsql/bin/slonik << _END_ # define the cluster namespace cluster name = bpixreplicate; # define two nodes connection information node 1 admin conninfo = 'dbname=bpix_live host=host1 user=postgres'; node 2 admin conninfo = 'dbname=bpix_live host=host2 user=postgres'; # node 2 subscribes to set 1 (node 1 to node 2) subscribe set (id=1, provider=1, receiver=2, forward=no); _END_ Here is the data in the "master" database in the "_bpixreplicate" schema select * from _bpixreplicate.sl_set; set_id | set_origin | set_locked | set_comment --------+------------+------------+----------------- 1 | 1 | | bpix statistics and select * from _bpixreplicate.sl_table ; tab_id | tab_reloid | tab_set | tab_idxname | tab_altered | tab_comment --------+------------+---------+----------------------+-------------+---------------------------- 1 | 17415 | 1 | stdayalbumstats_pkey | t | statistics.stdayalbumstats 2 | 17417 | 1 | sthitstats_pkey | t | statistics.sthitstats 3 | 17489 | 1 | stsession_pkey | t | statistics.stsession 4 | 17504 | 1 | sturllog_pkey | t | statistics.sturllog And here is the script to set replication up ======================================= slonik script to setup replication ======================================= #!/bin/bash /usr/local/pgsql/bin/slonik << _END_ # define the cluster namespace cluster name = bpixreplicate; # define two nodes connection information node 1 admin conninfo = 'dbname=bpix_live host=host1 user=postgres'; node 2 admin conninfo = 'dbname=bpix_live host=host2 user=postgres'; # create the first node and cluster # this is the master init cluster (id=1, comment='host1 Master 7.4.4'); # create the second slave node store node (id=2, comment='host2 Slave 7.4.6'); # create the replication sets create set (id=1, origin=1, comment='bpix statistics'); set add table (set id=1, origin=1, id=1, full qualified name='statistics.stdayalbumstats'); set add table (set id=1, origin=1, id=2, full qualified name='statistics.sthitstats'); set add table (set id=1, origin=1, id=3, full qualified name='statistics.stsession'); set add table (set id=1, origin=1, id=4, full qualified name='statistics.sturllog'); # define the paths between the servers store path (server=1, client=2, conninfo='dbname=bpix_live host=host1 user=postgres'); store path (server=2, client=1, conninfo='dbname=bpix_live host=host2 user=postgres'); # define the listeners and who provides the master data store listen (origin=1, provider=1, receiver=2); store listen (origin=2, provider=2, receiver=1); # node 2 subscribes to set 1 (node 1 to node 2) #subscribe set (id=1, provider=1, receiver=2, forward=no); _END_
- Previous message: [Slony1-general] 2 host slonik config question
- Next message: [Slony1-general] subscriber set error - help needed
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list