Maybe this page will help you with your problem:

http://cbbrowne.dyndns.info:8741/cgi-bin/twiki/view/Sandbox/SlonyFAQ06

"Evidently, you haven't got the xxid.so library in the $libdir directory 
that the PostgreSQL? instance is using. Note that the Slony-I components 
need to be installed in the PostgreSQL? software installation for each 
and every one of the nodes, not just on the "master node."

Tim

betty_sun0 wrote:
> Slony-I Member:
>         How do you do !
>  
>  I install Slony-I 's slony1-1.0.2.tar.gz and
>  slony1-1.0.5.tar.gz .then , run sh script:
>  #----------script start ------------------------
>  #!/bin/sh
>  
>  CLUSTERNAME=slony_db2
>  MASTERDBNAME=db2
>  SLAVEDBNAME=db2
>  MASTERHOST=10.10.11.12
>  SLAVEHOST=10.10.11.21
>  REPLICATIONUSER=postgre
>  PGBENCHUSER=postgre
>  
>  slonik <<_EOF_
>  cluster name = $CLUSTERNAME;
>  
>  node 1 admin conninfo = 'dbname=$MASTERDBNAME host=$MASTERHOST
>  user=$REPLICATIONUSER';
>  node 2 admin conninfo = 'dbname=$SLAVEDBNAME host=$SLAVEHOST
>  user=$PGBENCHUSER';
>  
>  init cluster ( id = 1, comment = 'Master Node' );
>  
>  #table add key (node id = 1, fully qualified name =
>  'public.history');
>  
>  create set ( id = 1, origin = 1, comment = 'All pgbench tables'
>  );
>  
>  set add table (set id=1 , origin=1 , id=1 , fully qualified name
>  = 'public.accounts' , comment='Table accounts');
>  set add table (set id=1 , origin=1 , id=2 , fully qualified name
>  = 'public.branches' , comment='Table branches');
>  set add table (set id=1 , origin=1 , id=3 , fully qualified name
>  = 'public.tellers' , comment='Table tellers');
>  #set add table (set id=1 , origin=1 , id=4 , fully qualified name
>  = 'public.history' , comment='history table' , key = serial);
>  
>  store node (id=2, comment = 'Slave node');
>  
>  store path (server = 1, client = 2, conninfo =
>  'dbname=$MASTERDBNAME host=$MASTERHOST user=$REPLICATIONUSER');
>  
>  store path ( server = 2, client = 1, conninfo =
>  'dbname=$SLAVEDBNAME host=$SLAVEHOST user=$PGBENCHUSER');
>  
>  store listen ( origin = 1, provider = 1, receiver = 2 );
>  store listen ( origin = 2, provider = 2, receiver = 1 );
>  _EOF_
>  #-------------script end----------------------
>  show Error:
>  <stdin>:39: PGRES_FATAL_ERROR load '$libdir/xxid'; - ERROR: could not access file "$libdir/xxid": No such file or directory
>  <stdin>:39: Error: the extension for the xxid data type cannot be loaded in database 'dbname=slony_db2 host=10.10.11.21 user=postgre'
>  
>  my os is : SunOS5.8
>  PostgreSQL version : 7.4
>  
>  Why have this error,I try set env variable libdir=path/lib
>  and at postgre db install direction have xxid.so
>  I look for network for answer,but no . Please help me.and tell me how
>  to resolve this Error. Thank you for your help very much .
> 
> ______________________________________
> 
> ??????????????????????2G???????? http://mail.sina.com.cn/chooseMode.html ??
> 
> ===================================================================
> ??????????????????-?????????????????????????? (http://ad4.sina.com.cn/wlw/all/zhuiyu.html)
> _______________________________________________
> Slony1-general mailing list
> Slony1-general at gborg.postgresql.org
> http://gborg.postgresql.org/mailman/listinfo/slony1-general


-- 
Tim Goodaire    416-673-4126    tgoodair at ca.afilias.info
Database Administrator, Afilias Canada Corp.