Ok,
I'm trying to setup a 4 node cluster that I had working fine in Slony-I 1.x & PostgreSQL 8.3.x and running into a major problem.

This is on Windows Server 2008 R2 (currently our only choice for the web app that uses the DB).

I get the following errors when I try to subscribe the client nodes to the master, they appear as subscriptions in the master database but the clients never subscribe.  I am at my wits end and about to wipe the servers out and then reinstall Windows, PostgreSQL, everything else I need.  I know I could go back to PostgreSQL 8.3 but I'd rather run 8.4 since it should be supported longer than 8.3 will be.  All the files I am using for the process are listed below.  The guide I'm using is located at http://www.enterprisedb.com/learning/tutorial/slony_postgresql.do

Any help anyone can provide will be very helpful.

C:\cluster>slonik subscribeset.sk
subscribeset.sk:5: NOTICE:  subscribe set: omit_copy=f
subscribeset.sk:5: NOTICE:  subscribe set: omit_copy=f
CONTEXT:  SQL statement "SELECT  "_ncnccluster".subscribeSet_int( $1 ,  $2 ,  $3 ,  $4 ,  $5 )"
PL/pgSQL function "subscribeset" line 68 at PERFORM
subscribeset.sk:6: NOTICE:  subscribe set: omit_copy=f
subscribeset.sk:6: NOTICE:  subscribe set: omit_copy=f
CONTEXT:  SQL statement "SELECT  "_ncnccluster".subscribeSet_int( $1 ,  $2 ,  $3 ,  $4 ,  $5 )"
PL/pgSQL function "subscribeset" line 68 at PERFORM
subscribeset.sk:7: NOTICE:  subscribe set: omit_copy=f
subscribeset.sk:7: NOTICE:  subscribe set: omit_copy=f
CONTEXT:  SQL statement "SELECT  "_ncnccluster".subscribeSet_int( $1 ,  $2 ,  $3 ,  $4 ,  $5 )"
PL/pgSQL function "subscribeset" line 68 at PERFORM

The files I'm using for building the replication cluster are as follows (using the guide I found at EnterpriseDB)

Preamble.sk
# file preamble.sk

cluster name = ncnccluster;
node 1 admin conninfo = 'dbname=ncnc host=192.168.7.80 user=sde password=geocomm';
node 2 admin conninfo = 'dbname=ncnc host=192.168.7.81 user=sde password=geocomm';
node 3 admin conninfo = 'dbname=ncnc host=192.168.7.82 user=sde password=geocomm';
node 4 admin conninfo = 'dbname=ncnc host=192.168.7.83 user=sde password=geocomm';

Initcluster.sk
# file initcluster.sk

include <preamble.sk>;

init cluster (id=1, comment='hostname=192.168.7.80');

Addnode.sk
# file addnode.sk

include <preamble.sk>;

store node (id=2, comment='hostname=192.168.7.81', event node=1);
store node (id=3, comment='hostname=192.168.7.82', event node=1);
store node (id=4, comment='hostname=192.168.7.83', event node=1);

Addpaths.sk
# file addpaths.sk

include <preamble.sk>;

store path (server=1, client=2, conninfo='dbname=ncnc host=192.168.7.80 user=sde password=password');
store path (server=1, client=3, conninfo='dbname=ncnc host=192.168.7.80 user=sde password=password');
store path (server=1, client=4, conninfo='dbname=ncnc host=192.168.7.80 user=sde password=password');
store path (server=2, client=1, conninfo='dbname=ncnc host=192.168.7.81 user=sde password=password');
store path (server=2, client=3, conninfo='dbname=ncnc host=192.168.7.81 user=sde password=password');
store path (server=2, client=4, conninfo='dbname=ncnc host=192.168.7.81 user=sde password=password');
store path (server=3, client=1, conninfo='dbname=ncnc host=192.168.7.82 user=sde password=password');
store path (server=3, client=2, conninfo='dbname=ncnc host=192.168.7.82 user=sde password=password');
store path (server=3, client=4, conninfo='dbname=ncnc host=192.168.7.82 user=sde password=password');
store path (server=4, client=1, conninfo='dbname=ncnc host=192.168.7.83 user=sde password=password');
store path (server=4, client=2, conninfo='dbname=ncnc host=192.168.7.83 user=sde password=password');
store path (server=4, client=3, conninfo='dbname=ncnc host=192.168.7.83 user=sde password=password');

192.168.7.80.slon
# file 192.168.7.80.slon

cluster='ncnccluster'
conn_info='dbname=ncnc host=192.168.7.80 user=sde password=password'

192.168.7.81.slon
# file 192.168.7.81.slon

cluster='ncnccluster'
conn_info='dbname=ncnc host=192.168.7.81 user=sde password=password'

192.168.7.82.slon
# file 192.168.7.82.slon

cluster='ncnccluster'
conn_info='dbname=ncnc host=192.168.7.82 user=sde password=password'

192.168.7.83.slon
# file 192.168.7.83.slon

cluster='ncnccluster'
conn_info='dbname=ncnc host=192.168.7.83 user=sde password=password'

Buildset.sk
# file buildset.sk

include <preamble.sk>;

create set (id=1, origin=1, comment='NCNC Regional Dataset');

Addtables.sk
# file addtables.sk

include <preamble.sk>;

set add table(set id=1,origin=1, id=1, fully qualified name='sde.alt_routing',key='ar_pk',comment='Alternate routing data');
set add table(set id=1,origin=1, id=2, fully qualified name='sde.centerline',key='cl_pk',comment='Centerline data');
set add table(set id=1,origin=1, id=3, fully qualified name='sde.county',key='ct_pk',comment='County data');
set add table(set id=1,origin=1, id=4, fully qualified name='sde.fire_service_boundary',key='fsb_pk',comment='Fire service boundary data');
set add table(set id=1,origin=1, id=5, fully qualified name='sde.law_service_boundary',key='lsb_pk',comment='Law service boundary data');
set add table(set id=1,origin=1, id=6, fully qualified name='sde.medical_service_boundary',key='msb_pk',comment='Medical service boundary data');
set add table(set id=1,origin=1, id=7, fully qualified name='sde.municpal_boundary',key='mb_pk',comment='Municpal boundary data');
set add table(set id=1,origin=1, id=8, fully qualified name='sde.psap',key='psap_pk',comment='PSAP data');
set add table(set id=1,origin=1, id=9, fully qualified name='sde.rescue_service_boundary',key='rsb_pk',comment='Rescue service boundary data');
set add table(set id=1,origin=1, id=10, fully qualified name='sde.structures',key='s_pk',comment='Structures data');

Subscribeset.sk
# file subscribeset.sk

include <preamble.sk>;

subscribe set (id=1, provider=1, receiver=2, forward=yes);
sync(id=1);
wait for event (origin=1, confirmed=2, wait on=1);
subscribe set (id=1, provider=1, receiver=3, forward=yes);
sync(id=1);
wait for event (origin=1, confirmed=3, wait on=1);
subscribe set (id=1, provider=1, receiver=4, forward=yes);
sync(id=1);
wait for event (origin=1, confirmed=4, wait on=1);


Shaun McCloud - Software Testing Analyst
GeoComm Inc.
601 W. Saint Germain St., Saint Cloud, MN 56301
Office: 320.240.0040 Fax: 320.240.2389 Toll Free: 888.436.2666
click here to visit www.geo-comm.com<http://www.geo-comm.com/>
Microsoft Certified Desktop Support Technician (MCDST)
Do or do not, there is no try.
    -Yoda

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20101217/21378f16/attachment.htm