Thanks for the info - that explains my problem.

You're right about more testing offline but that isn't an option for us 
right now.

At least it is now replicating. In fact it's performing excellently - 
what a really great piece of software!

I will investigate failover and promotion soon (before I have to do it 
for real!).

Thanks for you help

John Sidney-Woollett

Darcy Buskermolen wrote:

> 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
> 
>