betty_sun0 ambetty
Thu Dec 2 05:01:19 PST 2004
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)


More information about the Slony1-general mailing list