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

On Dec 17, 2007 3:14 PM, Shane Ambler <pgsql@sheeky.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

"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