Hi all,

I'm having troubles with slony updating postgres 8.1 -> 8.3
I'm running postgres 8.3 on FreeBSD 6.3 amd64 and slony 1.2.15.
I updated Postgres via portupgrade and then rebuilt slony from ports
(make clean; make; make deinstall; make install)

Everithing goes perfect, but when I run my slonik script to configure
my nodes I got the following error:

<stdin>:5: PGRES_FATAL_ERROR load '$libdir/xxid';  - ERROR:
incompatible library "/usr/local/lib/postgresql/xxid.so": missing
magic block
HINT:  Extension libraries are required to use the PG_MODULE_MAGIC
macro.
<stdin>:5: Error: the extension for the xxid data type cannot be
loaded in database 'dbname=sso host=replicabd.mecon.ar user=slony'

The line that is failing is:

  store node (id=$id_slavehost, comment='Nodo esclavo');

I saw if xxid.so were updated after rebuild and it is.
The thing that is suspicious to me is that the code of xxid.c includes
the call to PG_MODULE_MAGIC but does not include library fmgr.h

Here is the complete slonik script:

        cluster name = $slony_cluster;
        node $id_masterhost admin conninfo = 'dbname=$slony_masterdb
host=$slony_masterhost user=$slony_replicationuser';
        node $id_slavehost admin conninfo = 'dbname=$slony_slavedb
host=$slony_slavehost user=$slony_replicationuser';
        init cluster (id=$id_masterhost, comment='Nodo principal');
        store node (id=$id_slavehost, comment='Nodo esclavo');
        store path (server=$id_masterhost, client=$id_slavehost,
conninfo='dbname=$slony_masterdb host=$slony_masterhost
user=$slony_replicationuser');
        store path (server=$id_slavehost, client=$id_masterhost,
conninfo='dbname=$slony_slavedb host=$slony_slavehost
user=$slony_replicationuser');


Thanks in advance for any advice,

Greetings

Emiliano