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<[email protected]> >>> Sender: [email protected] >>> Date: Tue, 13 Sep 2011 12:33:28 >>> To:<[email protected]> >>> 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 > [email protected] > http://lists.slony.info/mailman/listinfo/slony1-general -- Dan Goodliffe 07970 523693 [email protected] _______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
