On 12-06-14 12:44 PM, Shaun McCloud wrote: > Has to be in the same directory as the slonik executable. Got the cluster > built, everything setup and am going to attempt to turn it on shortly. > However, clicking anything in pgAdmin III related to Slony gives me the > following. > > 2012-06-14 11:39:19 INFO : Displaying properties for Slony-I cluster > test_repset > 2012-06-14 11:39:19 STATUS : Retrieving Slony-I cluster details... > 2012-06-14 11:39:19 QUERY : Scalar query (localhost:5432): SELECT > listenerpid FROM pg_listener WHERE relname = '_test_repset_Event' > 2012-06-14 11:39:19 ERROR : ERROR: relation "pg_listener" does not exist > LINE 1: SELECT listenerpid FROM pg_listener WHERE relname = '_test_r...
I doubt pgadmin III works with slony 2.1 I don't know if the pgadmin guys have been keeping up to date with slony changes (I'm not even sure how well it work with slony 2.0). I suspect this isn't a MS-Windows issue. > > Also, the WIN32 compile instructions don't list how to compile slevent.dll, > is there a way to do this to make "pretty" error messages in the Windows > Event Viewer? Or would a version of the DLL from Slony 2.0.4 work for that > single use? > You shouldn't need slevent.dll anymore. Is it pgadmin that tries to use it or something else? > Shaun McCloud, MCDST | Associate Software Developer > Geo-Comm Inc. | www.geo-comm.com > > > -----Original Message----- > From: Steve Singer [mailto:[email protected]] > Sent: Thursday, June 14, 2012 09:33 > To: Shaun McCloud > Cc: [email protected] > Subject: Re: [Slony1-general] Slony-I 2.1 with PostgreSQL 9.0.8 x86-64 > > On 12-06-14 10:30 AM, Shaun McCloud wrote: >> I guess I spoke to soon. I get an error trying to run slonik saying "The >> program can't start because MSVCR90.dll is missing from your computer. Try >> reinstalling the program to fix this problem.". Do the MS Visual C++ 2008 >> redistributables need to be installed? >> > > Make sure that file (It comes somewhere in the SDK, use search to find > where) is either in the same directory as your slonik binary file, or is in > your PATH (I forget which one). > > > >> Shaun McCloud, MCDST | Associate Software Developer Geo-Comm Inc. | >> www.geo-comm.com >> >> -----Original Message----- >> From: Shaun McCloud >> Sent: Wednesday, June 13, 2012 14:51 >> To: Shaun McCloud; Steve Singer >> Cc: [email protected] >> Subject: RE: [Slony1-general] Slony-I 2.1 with PostgreSQL 9.0.8 x86-64 >> >> Actually, just switching it to the 64-bit lib folder for pthreads got it >> working. Although now comes the fun time of setting this up. >> >> Shaun McCloud, MCDST | Associate Software Developer Geo-Comm Inc. | >> www.geo-comm.com >> >> >> -----Original Message----- >> From: [email protected] >> [mailto:[email protected]] On Behalf Of Shaun >> McCloud >> Sent: Wednesday, June 13, 2012 14:48 >> To: Steve Singer >> Cc: [email protected] >> Subject: Re: [Slony1-general] Slony-I 2.1 with PostgreSQL 9.0.8 x86-64 >> >> There is, I will try that shortly. Just found PostgreSQL 9.0.8.1 so I am >> going to update to that just in case. >> >> Shaun McCloud, MCDST | Associate Software Developer Geo-Comm Inc. | >> www.geo-comm.com >> >> >> -----Original Message----- >> From: [email protected] >> [mailto:[email protected]] On Behalf Of Steve >> Singer >> Sent: Wednesday, June 13, 2012 14:45 >> To: Shaun McCloud >> Cc: [email protected] >> Subject: Re: [Slony1-general] Slony-I 2.1 with PostgreSQL 9.0.8 x86-64 >> >> On 12-06-13 03:28 PM, Shaun McCloud wrote: >>> Using pthreads 2.9.1 and gettext runtime .013.1 I get the attached error >>> when running "nmake /f win32.mak slon.exe". Below are my environment >>> variables. Do you think it would it be worth reinstalling PostgreSQL in a >>> path without spaces? >> >> >> Just guessing but >> >> >>> >>> set PG_INC="c:\\Program Files\\PostgreSQL\\9.0\\include" >>> set PG_LIB="c:\\Program Files\\PostgreSQL\\9.0\\lib" >>> set PGSHARE="c:\\Program Files\\PostgreSQL\\9.0\\share" >>> set PTHREADS_INC=c:\\Dev\\pthreads\\include >>> set PTHREADS_LIB=c:\\Dev\\pthreads\\lib\\x86 >> >> Is there a x86-64 lib for pthreads? Do you need one? >> >> >>> set GETTEXT_LIB=c:\\Dev\\gettext\\lib >>> >>> Shaun McCloud, MCDST | Associate Software Developer Geo-Comm Inc. | >>> www.geo-comm.com >>> >>> >>> -----Original Message----- >>> From: Steve Singer [mailto:[email protected]] >>> Sent: Wednesday, June 13, 2012 13:44 >>> To: Shaun McCloud >>> Cc: [email protected] >>> Subject: Re: [Slony1-general] Slony-I 2.1 with PostgreSQL 9.0.8 >>> x86-64 >>> >>> On 12-06-13 02:31 PM, Shaun McCloud wrote: >>>> Hello, >>>> >>>> I found the directions for building Slony-I on a Win32 platform. I >>>> am wondering if the same directions will work compiling against >>>> PostgreSQL >>>> 9.0 x86-64? Another component in our system requires the x86-64 >>>> version so we are stuck using it and we just ran into the issue >>>> where replication gets so far behind in Slony-I 2.0.4 (from Stack >>>> Builder) that it can't catch up so we are looking to upgrade. >>>> >>> >>> I've never tried it but I suspect it will. >>> If you hit any errors let me know and I will look into finding a >>> Windows >>> x86-64 environment to debug things in. >>> >>> >>> >>>> Shaun McCloud, MCDST | Associate Software Developer >>>> >>>> Geo-Comm Inc. | www.geo-comm.com<http://www.geo-comm.com/> >>>> >>>> 601 W. Saint Germain St., St. Cloud, MN, 56301 >>>> >>>> Office: 320.240.0040 or 888.436.2666 Fax: 320.240.2389 >>>> >>>> >>>> >>>> _______________________________________________ >>>> Slony1-general mailing list >>>> [email protected] >>>> http://lists.slony.info/mailman/listinfo/slony1-general >>> >> >> _______________________________________________ >> Slony1-general mailing list >> [email protected] >> http://lists.slony.info/mailman/listinfo/slony1-general >> _______________________________________________ >> Slony1-general mailing list >> [email protected] >> http://lists.slony.info/mailman/listinfo/slony1-general > _______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
