On Dec 17, 2007 3:14 PM, Shane Ambler <[EMAIL PROTECTED]> wrote: > Not sure I can help much, I only read out of interest, but thought > clarifying a few things may help. > > SHARMILA JOTHIRAJAH wrote: > > Hi I had posted this in the slony mailing list but no luck in getting > > any answers...Pls help me as I'm stuck with this error for the last 4 > > days > > > > > > > > Im trying to replicate between postgres version 7.4.18 and version > > 8.1.10. > > 7.4 is the master?
yes > > > > I configured postgres-7.4 with enable-thread-safety option > > > > I configured slony1 with this command > > > > ./configure --prefix=/export/home/josh/slony7.4 > > --enable-thread-safety > > --with-pgconfigdir=/export/home/josh/postgres7.4/bin > > --with-pgsourcetree=/export/home/josh/postgresql-7.4.18 > > > This is the 7.4 config? is the 8.1 config the same? > (your not building slony for 8.1 against a 7.4 source tree?) > > Are both versions running on the same machine? Yes > > > What version of Slony? same for both servers? Yes slony version 1.2.12 > > > > > > When i try to execute the this script > > On the 7.4 machine? yes > > > > #!/bin/sh > > > > slonik <<_EOF_ cluster name = slony_example; > > > > node 1 admin conninfo = 'dbname=$MASTERDBNAME host=$MASTERHOST > > user=$REPLICATIONUSER'; node 2 admin conninfo = 'dbname=$SLAVEDBNAME > > host=$SLAVEHOST user=$REPLICATIONUSER'; > > > > init cluster ( id=1, comment = 'Master Node'); > > > > create set (id=1, origin=1, comment='All pgbench tables'); set add > > table (set id=1, origin=1, id=1, fully qualified name = > > 'public.sample1', comment='accounts table'); store node (id=2, > > comment = 'Slave node'); > > > > store path (server = 1, client = 2, conninfo='dbname=$MASTERDBNAME > > host=$MASTERHOST user=$REPLICATIONUSER'); store path (server = 2, > > client = 1, conninfo='dbname=$SLAVEDBNAME host=$SLAVEHOST > > user=$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=testdb1 host=172.31.0.67 user=josh' > > <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? > > > > I sorted out the problem. I think I had too many postgres installations in my system. I removed them and compiled both postgresql and slony fro scratch and it just worked...Thanks again