Slony1 PostgreSQL Replication - Re: adding a 64bit server into the mix ... won't

Author

Re: adding a 64bit server into the mix ... won't

Jan Wieck

2006-04-03, 1:32 pm

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
> Slony1-general- AuKwsB3Fm+ugFIWk8tvy
RWD2FQJk+8+b@public.gmane.org
> http://gborg.postgresql.org/mailman.../slony1-general

--
#===================
====================
====================
===========#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#===================
====================
=========== JanWieck- bwPqjjyvM7QAvxtiuMwx
3w@public.gmane.org #

Marc G. Fournier

2006-04-03, 8:27 pm

On Mon, 3 Apr 2006, Jan Wieck wrote:

> On 3/30/2006 10:38 PM, Marc G. Fournier wrote:
>
> 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 :(

>
>
> --
> #===================
====================
====================
===========#
> # It's easier to get forgiveness for being wrong than for being right. #
> # Let's break this rule - forgive me. #
> #===================
====================
=========== JanWieck- bwPqjjyvM7QAvxtiuMwx
3w@public.gmane.org #
>
>

Sponsored Links