betty_sun0 ambetty
Wed Dec 1 12:30:36 PST 2004
Slony-I product member:
        How do you do!
    I try install Slony-I both version 1.0.2 and 1.0.5 hava a 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'
this Error is run script :
#--------script content 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 content end ----------------------  
I try most method,but Error is alway like this.please help me!and tell me how to resolve this error.very much thank you for your help.

os : SunOS 5.8
postgre version : 7.4

wait and eager for your answer!
______________________________________

×¢²áÐÂÀËÃâ·ÑÓÊÏ䣬¼¤»î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