On Dec 17, 2007 10:17 AM, Christopher Browne <cbbrowne at ca.afilias.info>
wrote:

> "Josh Harrison" <joshques at gmail.com> writes:
> > 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
>
> One minor problem there...  The "--enable-thread-safety" option is
> unnecessary there.  It's not the Slony-I build that requires this
> option; it's the PostgreSQL build that needs it.
>
> > 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$MASTERDBN=
AME
> host=3D$MASTERHOST user=3D$REPLICATIONUSER');
> > store path (server =3D 2, client =3D 1, conninfo=3D'dbname=3D$SLAVEDBNA=
ME
> 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?
> >
> >
> > Please help as Im stuck with this error the last 4 days
>
> The question has been asked before on the mailing list...
>
> <
> http://lists.slony.info/pipermail/slony1-general/2006-September/004821.ht=
ml
> >
> --


Thanks....
I solved the problem.
I configured postgresql and slony again from the scratch and removed all the
other versions of postgres that I had installed in my system.And it worked
just fine now.
I still dont know what was giving the problem before !!!anyhow the problem
was solved..
Thanks again
josh
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20071217/=
9ea2d14d/attachment.htm