Slony1 PostgreSQL Replication - PGRES_FATAL

Author

PGRES_FATAL_ERROR load '$libdir/xxid'

Nuno Fernandes

2005-09-21, 11:24 am

Hello,

I've installed postgresql 7.3.10 using redhat rpms and included devel package.

I've installed slony using

../configure --includedir /usr/include/pgsql --with-perltools=/usr/bin
--datadir /usr/share/pgsql --sysconfdir=/etc --with-pglibdir=/usr/lib/pgsql
make
make install

Next i've started postgresql using service postgresql start.
All went ok.

When i try the following slonik script
# INIT CLUSTER
cluster name = tuxcluster;
node 1 admin conninfo='host=cl1 dbname=tux user=slony port=5432
password=123456';
node 2 admin conninfo='host=cl2 dbname=tux user=slony port=5432
password=123456';
init cluster (id = 1, comment = 'Node 1 - tux@cl1');

# STORE NODE
store node (id = 2, event node = 1, comment = 'Node 2 - tux@cl2');
echo 'Set up replication nodes';

# STORE PATH
echo 'Next: configure paths for each node/origin';
store path (server = 2, client = 1, conninfo = 'host=cl2 dbname=tux
user=slony port=5432 password=123456');
store path (server = 1, client = 2, conninfo = 'host=cl1 dbname=tux
user=slony port=5432 password=123456');

# STORE LISTEN
store listen (origin = 1, receiver = 2, provider = 1);
store listen (origin = 2, receiver = 1, provider = 2);
echo 'Replication nodes prepared';
echo 'Please start a slon replication daemon for each node';

I get the error:

<stdin>:9: PGRES_FATAL_ERROR load '$libdir/xxid'; - ERROR: LOAD: could not
open file '$libdir/xxid': No such file or directory
<stdin>:9: Error: the extension for the xxid data type cannot be loaded in
database 'host=cl2 dbname=tux user=slony port=5432 password=123456'

I've read the faq regarding this issue and i don't have any other postgresql
build environment. I've straced postgresql and it
opens /usr/lib/pgsql/xxid.so.

Thanks
Nuno Fernandes

Alan Hodgson

2005-09-21, 11:24 am

On Wed, Sep 21, 2005 at 04:16:12PM +0100, Nuno Fernandes wrote:
> I've read the faq regarding this issue and i don't have any other postgresql
> build environment. I've straced postgresql and it
> opens /usr/lib/pgsql/xxid.so.

Did you install Slony on cl2?

--
"We can no more blame our loss of freedom on Congressmen than we can
prostitution on pimps. Both simply provide broker services for their
customers." -- Dr. Walter Williams

Sponsored Links