On 11-01-24 10:20 AM, Ejber Ozkan wrote:
> I wish to test migrate from 8.1.15 to 9.0 of postgresql (yes very old!).
>
> slony1-1.2.22 compiled ok on 8.1 (FC10)
>
> but on CentOS 5.5 with Postgresql90 installed ( I only have to x64
> installed of 9.0 from the pgrpms).
>
> I get a compile error:
>
> gcc -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -I../..
> -DPGSHARE="\"/usr/pgsql-9.0/bin//../share/\"" -DPG_VERSION_MAJOR=9
> slonik.o dbutil.o parser.o ../parsestatements/scanner.o
> -L/usr/pgsql-9.0/lib/ -L/usr/pgsql-9.0/lib/ -lpq
> -Wl,-rpath,/usr/pgsql-9.0/lib/ -lpgport -o slonik
>
> /usr/bin/ld: skipping incompatible /usr/pgsql-9.0/lib//libpgport.a when
> searching for -lpgport
>
> /usr/bin/ld: skipping incompatible /usr/pgsql-9.0/lib//libpgport.a when
> searching for -lpgport
>
> /usr/bin/ld: cannot find -lpgport
>
> collect2: ld returned 1 exit status
>

I've usually seen that style of error with a conflict between 64 vs 32 
bit libraries.  You might want to double check that you have all the 64 
bit RPM's installed (I'm assuming you want to build 64 bit).

Also make sure you have the postgresql90-devel package installed.




> make[2]: *** [slonik] Error 1
>

> On a related note can I run slony 2.0 on PG 9.0 and replicate from 8.1
> with slony 1.2 ?, I couldn’t find an answer in the documentation about
> replication from different slony codebases.
>

No you must be running the same version of slony on all nodes in your 
cluster.

> Thanks.
>
> *Ejber Ozkan***
>
>
>
> _______________________________________________
> Slony1-general mailing list
> Slony1-general at lists.slony.info
> http://lists.slony.info/mailman/listinfo/slony1-general