On 11/2/2004 6:36 PM, Justin Clift wrote:

> Hi all,
> 
> Using Slony 1.0.5 for a very simple 2 node master->slave arrangement in
> this setup that replicates two tables from the first node to the second.
> 
> Now I'm experimenting with creating a second set, having two different
> tables be replicated from the second node back to the first.
> 
> I *think* these commands to Slonik should do the trick, but they're
> generating an error at the end telling me the set isn't found:

Insert a

     wait for event (origin = 2, confirmed = 1);

right before the subscribe set and it'll be fine.


Jan

> 
> *******
> 
> slonik <<_EOF_
> 
> 	# Namespace to use
> 	cluster name = my_test;
> 
> 	# Connection strings
> 	node 1 admin conninfo = 'dbname=foo host=hosta user=postgres';
> 	node 2 admin conninfo = 'dbname=hostb user=postgres';
> 
> 	create set (id = 2, origin = 2, comment = 'return tables');
> 
> 	set add table (set id=2, origin=2, id=1, fully qualified name =
> 'public.third', comment='third table');
> 	set add table (set id=2, origin=2, id=2, fully qualified name =
> 'public.fourth', comment='fourth table');
> 
> 	subscribe set ( id = 2, provider = 2, receiver = 1, forward = no);
> 
> _EOF_
> 
> *******
> 
> This seems all straightforward, however the "subscribe set" command is
> generating this error:
> 
> *******
> 
> ERROR:  Slony-I: set 2 not found
> <stdin>:15: PGRES_FATAL_ERROR select "_my_test".subscribeSet(2, 2, 1,
> 'f');  - ERROR:  Slony-I: set 2 not found
> $
> 
> *******
> 
> How can the subscribe not be finding set two?  It found the set for the
> "set add table" command.
> 
> :(
> 
> Regards and best wishes,
> 
> Justin Clift
> 
> _______________________________________________
> Slony1-general mailing list
> Slony1-general at gborg.postgresql.org
> http://gborg.postgresql.org/mailman/listinfo/slony1-general


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