Nope, adding the 64-bit version to my path doesn't help. Same error. I am using the 64-bit version of PostgreSQL, however Windows still shows that slon.exe is a 32-bit process when I build the 2.1.1 version (which works fine).
Shaun McCloud, MCDST | Associate Software Developer Geo-Comm Inc. | www.geo-comm.com -----Original Message----- From: Steve Singer [mailto:[email protected]] Sent: Tuesday, November 20, 2012 14:26 To: Shaun McCloud Cc: [email protected] Subject: Re: [Slony1-general] Slony1 2.1.2 Windows Issue On 12-11-20 02:10 PM, Shaun McCloud wrote: > Even though I have installed both the 32-bit & 64-bit versions of the Visual > C 2008 Redistributable, it is not in my path. After adding > C:\Windows\SysWOW64 to get the 32-bit version of MSVCR90.dll in my path, I am > told that slon.exe has "made an attempt to load the C runtime library > incorrectly." > > This is really confusing me since I have compiled it on a system with the > same components installed before and it ran. Does adding the 64 bit version to your path help. I thought you had said you were using 64 bit postgresql (which would require a 64 bit slony1_funcs.dll, I would assume) > > 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: Monday, November 19, 2012 10:59 > To: Steve Singer > Cc: [email protected] > Subject: Re: [Slony1-general] Slony1 2.1.2 Windows Issue > > 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 > _______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
