Tried this:
cluster name = secframe_cluster;
node 1 admin conninfo = 'dbname=securityframework host=192.168.0.1 user=postgres';
node 2 admin conninfo = 'dbname=securityframework host=192.168.0.2 user=postgres';
lock set (id = 1, origin = 1);
wait for event (origin = 1, confirmed = 2);
move set (id = 1, old origin = 1, new origin = 2);
wait for event (origin = 1, confirmed = 2);
lock set (id = 2, origin = 1);
wait for event (origin = 1, confirmed = 2);
move set (id = 2, old origin = 1, new origin = 2);
wait for event (origin = 1, confirmed = 2);

got this:
CONFIG moveSet: set_id=1 old_origin=1 new_origin=2
FATAL  localListenThread: MOVE_SET but no provider found for set 2
INFO   remoteListenThread_2: disconnecting from 'dbname=securityframework host=192.168.0.2 user=postgres'


-----Original Message-----
From: Jan Wieck [mailto:JanWieck at Yahoo.com]
Sent: Wed 7/14/2004 2:23 PM
To: Guthrie, Jeremy
Cc: slony1-general at gborg.postgresql.org
Subject: Re: [Slony1-general] Several Questions
 
On 7/14/2004 9:51 AM, Guthrie, Jeremy wrote:

> 1st off, sorry about the difference in mail format, forced to use exchange for webmail.  yuck.
> 
> 1.  Makes sense, seems to work just fine.
> 
> 2.  I trimmed out the cluster name and tried to re-run. 

That's not what I suggested. Your script is missing the lines

     node 1 admin conninfo = ...;
     node 2 admin conninfo = ...;

> lock set (id = 1, origin = 1);
> wait for event (origin = 1, confirmed = 2);
> move set (id = 1, old origin = 1, new origin = 2);
> wait for event (origin = 1, confirmed = 2);
> 
> Same error.
> 
> 
> 3.  I don't see Node_ID in sl_event or sl_confirm.  What am I missing?

select con_origin, con_received,
         max(ev_seqno) as last_event,
         max(con_seqno) as last_replicated,
         max(ev_seqno) - max(con_seqno) as behind
         from _mycluster.sl_confirm, _mycluster.sl_event
         where con_origin = ev_origin
         and con_origin = _mycluster.getLocalNodeId('_mycluster')
         group by 1, 2;

This executed on the origin of the data set (master) will give you the 
desired information.


Jan

-- 
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck at Yahoo.com #