On Mon, 3 Apr 2006, Jan Wieck wrote:

> 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.

They were compiled, and I even checked using 'file' to make sure they were 
amd64 libraries ... what I ended up having to do is load the two shared 
libraries on the slave server *before* doing the store path step, and then 
everything appears to have worked fine ... not optimal, but it worked ;(

Please note that in my original, included below, I showed that I could 
load the respective modules from the client server, but I should have 
emphasized that more, sorry :(

>> <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
>> Slony1-general at gborg.postgresql.org
>> 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.                                  #
> #================================================== JanWieck at Yahoo.com #
>
>