Shaun McCloud smccloud at geo-comm.com
Thu Jun 14 11:00:35 PDT 2012
Yep, I pulled a copy of it from 2.0.4 and it works fine.  Since all it does it some translation it isn't probably a huge deal to get it done anytime soon :)

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, June 14, 2012 12:59
To: Shaun McCloud
Cc: Slony1-general at lists.slony.info
Subject: Re: [Slony1-general] Slony-I 2.1 with PostgreSQL 9.0.8 x86-64

On 12-06-14 01:45 PM, Shaun McCloud wrote:
> Slevent.dll is used by Windows Event Viewer to make it easier to read Application event logs from Slony.

The old version (from 2.0.x) should work fine.

I'll try to write up a Visual C makefile to build that as well (I hadn't realized what that was used for)


>
> 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, June 14, 2012 12:40
> To: Shaun McCloud
> Cc: Slony1-general at lists.slony.info
> Subject: Re: [Slony1-general] Slony-I 2.1 with PostgreSQL 9.0.8 x86-64
>
> 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:ssinger at ca.afilias.info]
>> Sent: Thursday, June 14, 2012 09:33
>> To: Shaun McCloud
>> Cc: Slony1-general at lists.slony.info
>> 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: Slony1-general at lists.slony.info
>>> 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: slony1-general-bounces at lists.slony.info
>>> [mailto:slony1-general-bounces at lists.slony.info] On Behalf Of Shaun
>>> McCloud
>>> Sent: Wednesday, June 13, 2012 14:48
>>> To: Steve Singer
>>> Cc: Slony1-general at lists.slony.info
>>> 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: slony1-general-bounces at lists.slony.info
>>> [mailto:slony1-general-bounces at lists.slony.info] On Behalf Of Steve
>>> Singer
>>> Sent: Wednesday, June 13, 2012 14:45
>>> To: Shaun McCloud
>>> Cc: Slony1-general at lists.slony.info
>>> 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:ssinger at ca.afilias.info]
>>>> Sent: Wednesday, June 13, 2012 13:44
>>>> To: Shaun McCloud
>>>> Cc: Slony1-general at lists.slony.info
>>>> 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
>>>>> Slony1-general at lists.slony.info
>>>>> http://lists.slony.info/mailman/listinfo/slony1-general
>>>>
>>>
>>> _______________________________________________
>>> Slony1-general mailing list
>>> Slony1-general at lists.slony.info
>>> http://lists.slony.info/mailman/listinfo/slony1-general
>>> _______________________________________________
>>> 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