I tried again from within PGAdmin III and got told that it couldn't execute SELECT _ncnccluster.subscribeset

Since the servers have to be shipped out next week, I am just going to roll back to PostgreSQL 8.3.x since I know I can get that working and then do more testing with 8.4 in the lab.

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
Microsoft Certified Desktop Support Technician (MCDST) 
Do or do not, there is no try.
    -Yoda


-----Original Message-----
From: slony1-general-bounces at lists.slony.info [mailto:slony1-general-bounces at lists.slony.info] On Behalf Of Christopher Browne
Sent: Friday, December 17, 2010 12:09
To: Steve Singer
Cc: slony1-general at lists.slony.info
Subject: Re: [Slony1-general] Slony-I 2.0.4-1 & PostgreSQL 8.4.6 Problem

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"
_______________________________________________
Slony1-general mailing list
Slony1-general at lists.slony.info
http://lists.slony.info/mailman/listinfo/slony1-general