slony error --need help

From: SHARMILA JOTHIRAJAH <sharmi_jo(at)yahoo(dot)com>
To: General postgres mailing list <pgsql-general(at)postgresql(dot)org>
Subject: slony error --need help
Date: 2007-12-17 14:15:16
Message-ID: 590373.1251.qm@web31108.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

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

When i try to execute the this script

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

Thanks in advance

josh

____________________________________________________________________________________
Be a better friend, newshound, and
know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Will 2007-12-17 16:03:29 Re: Planner ignoring to use INDEX SCAN
Previous Message Bruce Momjian 2007-12-17 14:01:36 Re: Killing a session in windows