On 12/2/2004 12:01 AM, 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'

I assume this error is in response to the "store node (id=2, ..." line. 
The line breaks make it rather impossible to tell for real.

This would mean that on the server with IP address 10.10.11.21 the Slony 
installation wasn't done correctly. Please note that $libdir does NOT 
reference any environment variable presing in the slonik or even 
postmaster environment. It is the compile time decided library directory 
hard coded into the PostgreSQL server process. It is the same location 
where PostgreSQL installed the plpgsql loadable object.


Jan

-- 
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck at Yahoo.com #