Thread: slony error --need help

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?

> 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?

What version of Slony? same for both servers?

>
> When i try to execute the this script

On the 7.4 machine?

> #!/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?
>


--

Shane Ambler
pgSQL (at) Sheeky (dot) Biz

Get Sheeky @ http://Sheeky.Biz

SHARMILA JOTHIRAJAH wrote:
> 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

Does this file exist on the host in question?
Does the postgres user have permission to access it?
Is there anything else (e.g. selinux) that could interfere with access
to it?
What is different between your installations of 7.4, 8.1, 8.2 on host
172.31.0.67? Were they all compiled from source?

--
   Richard Huxton
   Archonet Ltd

"Josh Harrison" <joshques@gmail.com> writes:
>> What version of Slony? same for both servers?

> Yes slony version 1.2.12

Judging from the error message, you can't do that --- you need at least
different versions of the .so file for 7.4 and 8.1.
(GetTopTransactionId did not exist in 7.4.)  But this is the wrong place
to be asking about that; the slony lists would have people who know
more.

            regards, tom lane