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..
_______________________________________________
Slony1-general mailing list
[email protected]
http://lists.slony.info/mailman/listinfo/slony1-general
