Hi
Im trying to replicate between postgres version 7.4.18 and version 8.1.10.
I configured postgres-7.4 with enable-thread-safety option
I configured slony1 with this command
./configure --prefix=3D/export/home/josh/slony7.4 --enable-thread-safety
--with-pgconfigdir=3D/export/home/josh/postgres7.4/bin
--with-pgsourcetree=3D/export/home/josh/postgresql-7.4.18

When i try to execute the this script
#!/bin/sh
slonik <<_EOF_
        cluster name =3D slony_example;
        node 1 admin conninfo =3D 'dbname=3D$MASTERDBNAME host=3D$MASTERHOST
user=3D$REPLICATIONUSER';
        node 2 admin conninfo =3D 'dbname=3D$SLAVEDBNAME host=3D$SLAVEHOST
user=3D$REPLICATIONUSER';
        init cluster ( id=3D1, comment =3D 'Master Node');
        create set (id=3D1, origin=3D1, comment=3D'All pgbench tables');
       set add table (set id=3D1, origin=3D1, id=3D1, fully qualified name =
=3D '
public.sample1', comment=3D'accounts table');
        store node (id=3D2, comment =3D 'Slave node');
        store path (server =3D 1, client =3D 2, conninfo=3D'dbname=3D$MASTE=
RDBNAME
host=3D$MASTERHOST user=3D$REPLICATIONUSER');
        store path (server =3D 2, client =3D 1, conninfo=3D'dbname=3D$SLAVE=
DBNAME
host=3D$SLAVEHOST user=3D$REPLICATIONUSER');
_EOF_

I get theis error
<stdin>:21: PGRES_FATAL_ERROR load '$libdir/xxid';  - ERROR:  could not load
library "/export/home/josh/postgres7.4/lib/xxid.so": ld.so.1: postgres:
fatal: relocation error: file /export/home/josh/postgres7.4/lib/xxid.so:
symbol GetTopTransactionId: referenced symbol not found
<stdin>:21: Error: the extension for the xxid data type cannot be loaded in
database 'dbname=3Dtestdb1 host=3D172.31.0.67 user=3Djosh'
<stdin>:21: ERROR: no admin conninfo for node 134701624

The same works fine between postgresql versions 8.1.10 and 8.2.5 .
Why do I get this error when replicating between versions 7.4 and8.1. Does
slony1 replicate between these 2 versions? If so is there any other settings
that needs to be done?

Thanks in advance
josh
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20071216/=
22231124/attachment.htm