On January 17, 2005 11:51 am, John Sidney-Woollett wrote:
> Setup before subscribe.
>
> I've got it working now, but I had to start the slon jobs on both
> servers before I was able to get slonik to accept the subscribe script
> without errors.
>
> Is that always the case? You have to have the slon jobs running before
> you can subscribe?
Yes that is always the case that slon needs to be running before subscribe 
will happen.

>
> What happens after I stop and start the two slon jobs - will I have to
> resubscribe again?

No, once the subscription is complete you won;t have to run slonik scripts 
again.

>
> This is a live setup and I can do limited testing...
I'd sugust you follow the examples in the how-to on a separate system to 
familiarize yourself with how slony works and how to do promotion and 
failover.


>
> John Sidney-Woollett
>
> Darcy Buskermolen wrote:
> > What order are you running these 2 scripts ??
> >
> > On January 17, 2005 10:00 am, John Sidney-Woollett wrote:
> >>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_
> >>
> >>_______________________________________________
> >>Slony1-general mailing list
> >>Slony1-general at gborg.postgresql.org
> >>http://gborg.postgresql.org/mailman/listinfo/slony1-general
>
> _______________________________________________
> Slony1-general mailing list
> Slony1-general at gborg.postgresql.org
> http://gborg.postgresql.org/mailman/listinfo/slony1-general

-- 
Darcy Buskermolen
Wavefire Technologies Corp.
ph: 250.717.0200
fx:  250.763.1759
http://www.wavefire.com