On Thu, Jul 22, 2010 at 2:35 PM, Steve Singer <ssinger at ca.afilias.info> wrote:
> Scott Marlowe wrote:
>
> <snip>
>
>> make distclean
>> ./configure --with-pgpkglibdir=/usr/lib/postgresql/8.3/lib/
>> --with-pgconfigdir=/usr/bin/pg_config
>> make
>>
>> output was:
>>
>> make[1]: Entering directory `/home/dgish/slony1-1.2.21/src'
>> make[2]: Entering directory `/home/dgish/slony1-1.2.21/src/xxid'
>> gcc -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fpic
>> -I../.. -I/usr/include/postgresql/
>> -I/usr/include/postgresql/8.4/server/  -c -o xxid.o xxid.c>> Scott Marlowe
>> wrote:
>
>
> So is this 8.4 or 8.3 your compiling against? (note the 8.4 in the -I
> above).
>
> Ubuntu allows both 8.4 and 8.3 to be installed at once (in theory). However
> when run /usr/lib/postgresql/8.3/bin/pg_config and
> /usr/lib/postgresql/8.4/bin/pg_config I see them both listing
> /usr/include/postgresql.   I'm not 100% sure which version
> /usr/include/postgresql/postgres.h is from
>
> I'm thinking that the pg_config with ubuntu on multi-version installations
> is broken.  It seems to put the 8.4 files in include/postgresql but the 8.3
> files (minus the libpq headers) in include/postgresql/8.3

yep, that's exactly it.  I tried moving the karmic repos to being
above all the others but that didn't help.

I've tried a few things to try to get it to use the karmic repos, but
I'm a bit frustrated right now and just want working pgsql and slony,
so I'll probably go with source installs on both.