Stéphane A. Schildknecht wrote:
> Martin Eriksson a écrit :
>   
>> Hi,
>>
>> I got a little test system where i got 2 postgres servers running,
>> master = 8.2.4, slave1 = 8.2.4
>>
>> both goth their own instance of slony as well (1.2.14)
>> and replication works fine between them
>>
>> So i intended to try a migration to 8.3.1. where i add the 8.3.1 as new
>> node to the master let it replicate completely then uninstall the old
>> slave1 node.
>> of course each database run on a different port.
>>
>> so i created a 3rd postgres installation of 8.3.1, and also installed
>> slony 1.2.14 on that one.
>> create the db and schema.
>> add the node info in the config file then try to issue
>>
>> slonik_store_node --config /tmp/slon_Test.conf 3 | /data/pgsql/bin/slonik
>> (this point to the 8.2.4 installation of the slonik_store_node)
>>
>> but i get:
>> <stdin>:7: PGRES_FATAL_ERROR load '$libdir/xxid';  - ERROR: 
>> incompatible library "/data/pgsql-8.3.1/lib/xxid.so": version mismatch
>> DETAIL:  Server is version 8.3, library is version 8.2.
>> <stdin>:7: Error: the extension for the xxid data type cannot be loaded
>> in database 'host=t1 dbname=slonyT user=u1 port=5434'
>>
>> same if i try to use the slonik from the 8.3.1 slony installation..
>>
>>
>> I know its not exactly ideal to be running this much one one machine..
>> but if anyone got some suggestions it would be most appreciated.
>>
>> or maybe i shouldn't add the 8.3.1 node in this way?
>>     
>
> It seems to me slony for 8.3.1 has been compiled using information coming from
> pg_config installed by 8.2. Am I wrong ?
>
> Regards,
>   
well i built it the following way:
while in the slony1-1.2.14 source folder:
./configure --prefix=/data/pgsql-8.3.1 
--with-perltools=/data/pgsql-8.3.1/slony 
--with-pgconfigdir=/data/pgsql-8.3.1/bin

make && make install

which feels like it should have used the 8.3.1 postgres correctly...

but maybe im missing something....
because obviously it doesn't like the lib....

the slony for the other two 2.8.4 dbs i built the same way but changing 
to the respective paths.

basically i built first for the master which is using the standard 
/data/pgsql/ then second one using /data/pgsql-8.2.4-test/ and last 
/data/pgsql-8.3.1/

started up slon_start for master and then node 2.
added the node 3 (8.3) in the config file, then tried the 
slonik_store_node and got the above message..