Thu Dec 2 05:01:19 PST 2004
- Previous message: [Slony1-general] memory overruns ...
- Next message: [Slony1-general] Slony-I Error! Please help me!Thank you!
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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)
- Previous message: [Slony1-general] memory overruns ...
- Next message: [Slony1-general] Slony-I Error! Please help me!Thank you!
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list