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