Re: slony error --need help

On Dec 17, 2007 3:14 PM, Shane Ambler <pgsql(at)sheeky(dot)biz> 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