On Fri, 16 May 2008, Christopher Browne wrote:

> Jeff Frost <jeff at frostconsultingllc.com> writes:
>> On Fri, 16 May 2008, Christopher Browne wrote:
>>
>>> Here are the release notes; as always, see the "front page" at slony.info to get
>>> URLs...
>>>
>>> RELEASE 1.2.14
>>
>> Hrmmm..I get this when trying to update functions:
>>
>> ./upgrade.slonik:5: Possible unsupported PostgreSQL version 8.3,
>> defaulting to 8.1 support
>>
>> Thats' updating from 1.2.14rc to 1.2.14.
>>
>> This is what is said in my configure:
>>
>> pg_config says pg_bindir is /usr/bin/
>> pg_config says pg_libdir is /usr/lib64/
>> pg_config says pg_includedir is /usr/include/
>> pg_config says pg_pkglibdir is /usr/lib64/pgsql/
>> pg_config says pg_includeserverdir is /usr/include/pgsql/server/
>> checking for correct version of PostgreSQL... 8.3
>> pg_config says pg_sharedir is /usr/share/pgsql/
>>
>> so that seems fine.
>
> On the "good news" side, 8.1 support should work out fine, as the
> internals (e.g. - stored procs) do not vary between 8.1 and 8.3.
>
> But the line of code that should be recognizing version "80300" evidently isn't.
>
> This is the bit of logic that should be catching your version:  (slonik.c)
> 	else if ((adminfo->pg_version >= 80100) && adminfo->pg_version < 80400)	/* 8.1, 8.2 and 8.3 */
>
> Actually, there's one thing that makes me suspicious about this: your
> message differs from what it should.
>
> It should read:
>
> ./upgrade.slonik:5: Possible unsupported PostgreSQL version (80300) 8.3, defaulting to 8.1 support
>
> But perhaps I'm being overpicky...

Oh, you think it should be putting out the (80300) as well?  Maybe it's 
somehow running the wrong version?  I thought that myself and so I went and 
moved the 1.2.14 binaries and re-ran the install.  I configured with the 
following line:

./configure --prefix=/usr/local/slony1-1.2.14 --with-perltools=/usr/local/slony1-1.2.14/perl

Then I removed the /usr/local/slony symlink to 1.2.14rc and pointed it at 
/usr/local/slony1-1.2.14.  You think it's possible I ended up with two 
versions of the .so files somewhere?

I only found this file:

/usr/lib64/pgsql/slony1_funcs.so

Anything you'd like me to do to investigate further?

-- 
Jeff Frost, Owner 	<jeff at frostconsultingllc.com>
Frost Consulting, LLC 	http://www.frostconsultingllc.com/
Phone: 650-780-7908	FAX: 650-649-1954