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
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
