Yep, the 32 bit version of the Visual C++ 2008 Redistributable is installed. And if I do a "dir /s MSVCR90.dll" from the root of C: it finds the file in a location contained in my PATH variable. It has me stumped.
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: Friday, November 16, 2012 22:39 To: Shaun McCloud Cc: [email protected] Subject: Re: [Slony1-general] Slony1 2.1.2 Windows Issue On 12-11-16 11:35 AM, Shaun McCloud wrote: > 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). Is msvcr90.dll anywhere on your system? If so where? I would have expected this to be included in the runtime. http://support.microsoft.com/kb/326922 seems to indicate that Vcredist_x86.exe will install these. > > 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 _______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
