Nuno Fernandes npf-mlists
Wed Sep 21 16:17:05 PDT 2005
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 at cl1');

# STORE NODE
  store node (id = 2, event node = 1, comment = 'Node 2 - tux at 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


More information about the Slony1-general mailing list