Dan Goodliffe dan at randomdan.homeip.net
Tue Sep 13 15:29:40 PDT 2011
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