On 10-12-17 12:03 PM, Shaun McCloud wrote:
> 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.
>

What is the 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


None of those messages are errors, it looks to me like things might be 
working properly.  In windows I THINK slon logs to the windows event log 
(but I might be mistaken)   Did you see error messages from there 
indicating slon was having issues.

It also looks like that at least your first subscribe set finished 
successfully.