Mon Dec 17 07:17:58 PST 2007
- Previous message: [Slony1-general] Help pls---slony error ---PGRES_FATAL_ERROR load '$libdir/xxid'; the extension for the xxid data type cannot be loaded in database '
- Next message: [Slony1-general] Help pls---slony error ---PGRES_FATAL_ERROR load '$libdir/xxid'; the extension for the xxid data type cannot be loaded in database '
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
"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=/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 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 = 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? > > > 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.html> -- let name="cbbrowne" and tld="cbbrowne.com" in String.concat "@" [name;tld];; http://www3.sympatico.ca/cbbrowne/internet.html "Running Windows on a Pentium is like having a brand new Porsche but only be able to drive backwards with the handbrake on." -- (Unknown source)
- Previous message: [Slony1-general] Help pls---slony error ---PGRES_FATAL_ERROR load '$libdir/xxid'; the extension for the xxid data type cannot be loaded in database '
- Next message: [Slony1-general] Help pls---slony error ---PGRES_FATAL_ERROR load '$libdir/xxid'; the extension for the xxid data type cannot be loaded in database '
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list