Shaun McCloud smccloud at geo-comm.com
Fri Nov 16 05:51:04 PST 2012
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.

Shaun McCloud, MCDST | Associate Software Developer
Geo-Comm Inc. | www.geo-comm.com

-----Original Message-----
From: Steve Singer [mailto:ssinger at ca.afilias.info] 
Sent: Thursday, November 15, 2012 16:48
To: Shaun McCloud
Cc: slony1-general at lists.slony.info
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:ssinger at ca.afilias.info]
> Sent: Wednesday, November 14, 2012 14:31
> To: Shaun McCloud
> Cc: slony1-general at lists.slony.info
> 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:ssinger at ca.afilias.info]
>> Sent: Wednesday, November 14, 2012 14:07
>> To: Shaun McCloud
>> Cc: slony1-general at lists.slony.info
>> 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:ssinger at ca.afilias.info]
>>> Sent: Wednesday, November 14, 2012 13:42
>>> To: Shaun McCloud
>>> Cc: slony1-general at lists.slony.info
>>> 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
>>>> Slony1-general at lists.slony.info
>>>> http://lists.slony.info/mailman/listinfo/slony1-general
>>>>
>>>
>>
>



More information about the Slony1-general mailing list