Dan Goodliffe dan at randomdan.homeip.net
Tue Sep 13 15:34:32 PDT 2011
OK, it's slonik.c 1909 and 1995 in beta1.... I guess that could be 
different in more recent versions.

         else if ((adminfo->pg_version >= 90000) && (adminfo->pg_version 
< 90100)) /* 9.0 */

I changed the second version to 90200 to include all v9.1s, might be 
right, might not.

On 13/09/11 23:29, Dan Goodliffe wrote:
> I've been playing with 9.1 and slony 2.1.0 betas.
> Without digging into the code again (I can if you want) there are two
> places where it checks the server version number (major.minor in the
> form of 90100 I think) but treats anything above 90000 as unsupported
> and goes for 8.4 support... which doesn't work.
> I manually changed those points to be 90100 and it worked like charm.
>
> On 13/09/11 23:24, Steve Singer wrote:
>> CS DBA wrote:
>>> Setting up with a 9.1 rc1  master&   9.0.4 slave I get this:
>>>
>>>
>>> <stdin>:7: Possible unsupported PostgreSQL version (90100) 9.1,
>>> defaulting to 8.4 support
>>> <stdin>:19: loading of file
>>> /opt/app/postgres/91rc1/share//slony1_funcs.sql: PGRES_FATAL_ERROR
>>> ERROR:  could not find function "_Slony_I_resetSession" in file
>>> "/opt/app/postgres/904/lib/slony1_funcs.so"
>>> ERROR:  could not find function "_Slony_I_resetSession" in file
>>> "/opt/app/postgres/904/lib/slony1_funcs.so"
>>>
>> You don't tell us which version of slony you are using.
>> resetSession is a new function that was added sometime during the 2.1.0
>> betas.
>>
>> Is it possible that you are trying to use the 2.1.0 slony_funcs.sql file
>> with a slony 2.0.x shared library.  It *looks* like that from your
>> output  but if there is  another issue with 2.1.0 we'd like to know
>> about it.
>>
>> As Chris said both of us have done testing against 9.1 betas with 2.1.0
>> and 2.0.7.  You will see the "Possible unsupported PostgreSQL
>> version..." message because we didn't want to remove that until 9.1 was
>> actually released.
>>
>> Steve
>>
>>
>>> Thoughts?
>>>
>>>
>>>
>>>
>>>
>>>
>>>> Doesn't 2.0?
>>>>
>>>> Jan
>>>> --
>>>> Sent from a mobile device
>>>>
>>>> -----Original Message-----
>>>> From: CS DBA<cs_dba at consistentstate.com>
>>>> Sender: slony1-general-bounces at lists.slony.info
>>>> Date: Tue, 13 Sep 2011 12:33:28
>>>> To:<slony1-general at lists.slony.info>
>>>> Subject: [Slony1-general] PostgreSQL 9.1 support?
>>>>
>>>> Hi All;
>>>>
>>>> Anyone know if/when and what version of SLONY will support PostgreSQL 9.1?
>>>>
>>>>
>>>> Thanks in advance
>>>>
>>>>
>> _______________________________________________
>> Slony1-general mailing list
>> Slony1-general at lists.slony.info
>> http://lists.slony.info/mailman/listinfo/slony1-general

-- 
Dan Goodliffe
07970 523693
dan.goodliffe at randomdan.homeip.net



More information about the Slony1-general mailing list