Steve Singer <ssinger at ca.afilias.info> writes:
> 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.

Indeed, those are just NOTICE messages, added in at the start of the
function subscribeSet() and subscribeSet_int(), presumably as part of
the process of validating functionality of omit_copy.

Those messages should get removed; I'll see about doing that in HEAD.

There could be a problem here, but the messages that are being indicated
don't indicate problems.
-- 
(format nil "~S@~S" "cbbrowne" "ca.afilias.info")
Christopher Browne
"Bother,"  said Pooh,  "Eeyore, ready  two photon  torpedoes  and lock
phasers on the Heffalump, Piglet, meet me in transporter room three"