According to:

http://cbbrowne.com/info/listenpaths.html


> In Slony-I version 1.1, a heuristic scheme is introduced to
> automatically generate listener entries.
> <snip>
> Any time sl_subscribe or sl_path are modified, RebuildListenEntries()
> will be called to revise the listener paths.


When I create a simple cluster (two nodes, one set), the 'subscribe set'
command fails unless I explicitly:

  store listen ( origin = 1, provider = 1, receiver = 2 );
  store listen ( origin = 2, provider = 2, receiver = 1 );

Shouldn't the RebuildListenEntries() take care of that for me?

The error message I get is: PGRES_FATAL_ERROR select
"_test".subscribeSet(1, 1, 2, 'f');  - ERROR:  Slony-I: set 1 not found

Sure enough, if I log into node 2, the _test.sl_set table is empty.

Why do I have to 'store listen' twice before I can 'subscribe set'?

TIA.

  ++ Murphy



-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://gborg.postgresql.org/pipermail/slony1-general/attachments/20050305/68f00ec8/attachment.html