On 3/30/2006 10:38 PM, Marc G. Fournier wrote:
> 'k, now I'm confused ... I just brought online a couple of 64bit
> servers, and figured I'd move one of my slaves onto it .. so, I make sure
> that slony 1.1.5 is installed, and since its replacing one of the older
> slaves, I've unconfigured everything and am just going to setup all the
> slaves from scratch ...
>
> But, when I try to set things up, using the same slony_master_setup.sh
> script I originally used when all servers were i386, I'm getting an odd
> error:
>
> <stdin>:16: Database ams subscribed to slaves
> <stdin>:26: PGRES_FATAL_ERROR load '$libdir/xxid'; - ERROR: could not load
> library "/usr/local/lib/postgresql/xxid.so": dlopen
> (/usr/local/lib/postgresql/xxid.so) failed:
> /usr/local/lib/postgresql/xxid.so: unsupported file layout
It appears as if the shared objects in the libdir are not compiled for
the new architecture, but got copied from somewhere. These are in
particular the xxid.so and the slony1_funcs.so files.
Try recompiling and reinstalling slony on that slave server.
Jan
> <stdin>:6: Initializing the cluster
> <stdin>:14: Database cluster initialized as Node 1
> <stdin>:15: Storing node 2
> <stdin>:23: Node 2 created
> <stdin>:24: Storing node 3
> <stdin>:26: Error: the extension for the xxid data type cannot be loaded in
> database 'dbname=ams host=mx2.hub.org port=5432 user=pgsql password={'
> <stdin>:28: Could not create Node 3!
>
> Now, node three is my new 64bit server ... but, if I load xxid.so
> manually, it appears to load fine:
>
> ams=# load '/usr/local/lib/postgresql/xxid.so';
> LOAD
> ams=# load '/usr/local/lib/postgresql/slony1_funcs.so';
> LOAD
> ams=# \q
>
> So, what am I overlooking? :(
>
> thanks ...
> _______________________________________________
> Slony1-general mailing list
> [email protected]
> http://gborg.postgresql.org/mailman/listinfo/slony1-general
--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== [EMAIL PROTECTED] #
_______________________________________________
Slony1-general mailing list
[email protected]
http://gborg.postgresql.org/mailman/listinfo/slony1-general