Followed your suggestion and copied slon.exe & slonik.exe to C:\PostgreSQL\9.0\bin and I'm no longer getting that error. However it is now complaining that it can't find MSVCR90.dll and I have the 2008 Visual C++ Redistributable installed (both x86 & x84_64).
Shaun McCloud, MCDST | Associate Software Developer Geo-Comm Inc. | www.geo-comm.com -----Original Message----- From: Steve Singer [mailto:[email protected]] Sent: Friday, November 16, 2012 07:58 To: Shaun McCloud Cc: [email protected] Subject: Re: [Slony1-general] Slony1 2.1.2 Windows Issue On 12-11-16 08:51 AM, Shaun McCloud wrote: > I actually created a clean Server 2008 R2 VM on my desktop to try it. After > install PostgreSQL 9.0.10-1 x64 & PostGIS 2.0 (which is the type of data we > need to replicate) I get another error stating "The program can't start > because LIBPQ.dll is missing from your computer. Try reinstalling the > program to fix this problem." Never seen it before so that is confusing me. I have seen that error when trying to run slon.exe or slonik.exe from the source directories. If/when I copy the binaries to c:\Program Files\Postgresql\9.1\bin (or whatever) and run them from there it finds libpq.dll in that same directory. > > Shaun McCloud, MCDST | Associate Software Developer Geo-Comm Inc. | > www.geo-comm.com > > -----Original Message----- > From: Steve Singer [mailto:[email protected]] > Sent: Thursday, November 15, 2012 16:48 > To: Shaun McCloud > Cc: [email protected] > Subject: Re: [Slony1-general] Slony1 2.1.2 Windows Issue > > On 12-11-14 03:34 PM, Shaun McCloud wrote: >> Yep, >> >> Restarted the service after copying the new slon1_funcs.dll. If you want, I >> can setup a Windows Development machine for you once I get home as I can >> determine who gets access to that easier than I can at work. > > Did you also stop the windows slon service, copy the new slon.exe and > then restart it? ( if you don't stop the service before copying > slon.exe the copy will fail because the file is in use) > > I've tried the 2.1.2 tar from the website plus the two changes I mentioned > in config_msvc.h on a Win32 (not 64) machine and I am able to init the > cluster via slonik and the slons seem to be running. > > Do you have a clean machine you can install this on? ie not the machine that > had binaries of your previous 2.1.2 without the fix installed? I'm not sure > why this works for me but not for you. > > > >> >> Shaun McCloud, MCDST | Associate Software Developer Geo-Comm Inc. | >> www.geo-comm.com >> >> >> -----Original Message----- >> From: Steve Singer [mailto:[email protected]] >> Sent: Wednesday, November 14, 2012 14:31 >> To: Shaun McCloud >> Cc: [email protected] >> Subject: Re: [Slony1-general] Slony1 2.1.2 Windows Issue >> >> On 12-11-14 03:09 PM, Shaun McCloud wrote: >>> Yes, >>> >>> Deleted my old source folder, copied a clean one in place, made the change, >>> then compiled. >>> >> >> Do you maybe have to restart the postgres.exe service after copying >> the new slony1_funcs.dll into the lib directory? (I'm guessing, I >> don't see another obvious reference to 2.1.1 in the code for the DLL >> and setting up a windows development box always takes me a bit of >> time) >> >> >> >>> Shaun McCloud, MCDST | Associate Software Developer Geo-Comm Inc. | >>> www.geo-comm.com >>> >>> >>> -----Original Message----- >>> From: Steve Singer [mailto:[email protected]] >>> Sent: Wednesday, November 14, 2012 14:07 >>> To: Shaun McCloud >>> Cc: [email protected] >>> Subject: Re: [Slony1-general] Slony1 2.1.2 Windows Issue >>> >>> On 12-11-14 02:53 PM, Shaun McCloud wrote: >>>> That fixed that issue. >>>> >>>> Now I am getting "please upgrade Slony-I shared module to version 2.1.2" >>> >>> Did you do a clean compile (and then install) the slony1_funcs.dll ? >>> >>>> >>>> Shaun McCloud, MCDST | Associate Software Developer Geo-Comm Inc. | >>>> www.geo-comm.com >>>> >>>> -----Original Message----- >>>> From: Steve Singer [mailto:[email protected]] >>>> Sent: Wednesday, November 14, 2012 13:42 >>>> To: Shaun McCloud >>>> Cc: [email protected] >>>> Subject: Re: [Slony1-general] Slony1 2.1.2 Windows Issue >>>> >>>> On 12-11-14 02:36 PM, Shaun McCloud wrote: >>>>> I have compiled Slony1 2.1.2 on Windows Server 2008 R2 (x64) >>>>> against PostgreSQL 9.0 x64 and I am getting the following errors on >>>>> startup. >>>>> >>>>> *Slony-I schema version is 2.1.2 >>>>> >>>>> *please upgrade Slony-I schema to version 2.1.1 >>>>> >>>>> *main: Node has wrong Slony-I schema or module version loaded >>>>> >>>>> The machines I am trying to run 2.1.2 has never had another >>>>> version of >>>>> Slony1 on them. Why would Slony1 2.1.2 want the 2.1.1 schema? >>>>> And what can I do to resolve the issue? >>>> >>>> Sorry, my bad I think. >>>> Change the file >>>> config_msvc.h >>>> >>>> #define SLONY_I_VERSION_STRING "2.1.1" >>>> #define SLONY_I_VERSION_STRING_DEC 2,1,1 >>>> >>>> To instead say >>>> #define SLONY_I_VERSION_STRING "2.1.2" >>>> #define SLONY_I_VERSION_STRING_DEC 2,1,2 >>>> >>>> >>>> and recompile everything >>>> >>>> >>>> >>>> >>>>> >>>>> 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
