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. _______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
