Help me please.....
my slony-I 1.2.9
postgre8.2.4
i've installed pgbench and plpgsql
I've make setup.sh like this, but there error messages
like under this??
#!/bin/sh
CLUSTER=test1
MASTERDBNAME=pgbench_node1
SLAVEDBNAME=pgbench_node2
MASTERHOST=localhost
SLAVEHOST=localhost
SLONY_USER=postgres
PGBENCH_USER=postgres
/usr/local/pgsql/bin/slonik <<_EOF_
    cluster name = $CLUSTER;
    node 1 admin conninfo = 'dbname=$MASTERDBNAME
host=$MASTERHOST user=$SLONY_USER';
    node 2 admin conninfo = 'dbname=$SLAVEDBNAME
host=$SLAVEHOST user=$SLONY_USER';
    init cluster ( id = 1, comment = 'Node 1' );
    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',
        key = serial,
        comment = 'Table history' );
        store node ( id = 2, comment = 'Node 2' );
    store path ( server = 1, client = 2,
        conninfo = 'dbname=$MASTERDBNAME
host=$MASTERHOST user=$SLONY_USER');
    store path ( server = 2, client = 1,
        conninfo = 'dbname=$SLAVEDBNAME
host=$SLAVEHOST user=$SLONY_USER');
    store listen ( origin = 1, provider = 1, receiver
= 2 );
    store listen ( origin = 2, provider = 2, receiver
= 1 );
_EOF_

there  were  error messages like this

<stdin>:4: Error: namespace "_test1" already exists in
database of node 1
<stdin>:4: ERROR: no admin conninfo for node 149930256



when i make the subscribe.sh like this

#!/bin/sh
CLUSTER=test1
MASTERDBNAME=pgbench_node1
SLAVEDBNAME=pgbench_node2
MASTERHOST=localhost
SLAVEHOST=localhost
SLONY_USER=postgres
PGBENCH_USER=postgres
/usr/local/pgsql/bin/slonik <<_EOF_
    cluster name = $CLUSTER;
   node 1 admin conninfo = 'dbname=$MASTERDBNAME
host=$MASTERHOST user=$SLONY_USER';
    node 2 admin conninfo = 'dbname=$SLAVEDBNAME
host=$SLAVEHOST user=$SLONY_USER';
    subscribe set ( id = 1, provider = 1, receiver =
2, forward = no);
_EOF_

there were  error messages like this : 

<stdin>:18: PGRES_FATAL_ERROR select
"_test1".subscribeSet(1, 1, 2, 'f');  - ERROR:  insert
or update on table "sl_path" violates foreign key
constraint "pa_client-no_id-ref"
DETAIL:  Key (pa_client)=(2) is not present in table
"sl_node".
CONTEXT:  SQL statement "INSERT INTO "_test1".sl_path
(pa_server, pa_client, pa_conninfo, pa_connretry)
values ( $1 ,  $2 , '<event pending>', 10)"
PL/pgSQL function "subscribeset_int" line 53 at SQL
statement
SQL statement "SELECT  "_test1".subscribeSet_int( $1 ,
 $2 ,  $3 ,  $4 )"
PL/pgSQL function "subscribeset" line 63 at perform

so,what happend in my replicator?? and what should i
do to solve this error

thank kyu
regards,
bayu



       
____________________________________________________________________________________
Be a better Heartthrob. Get better relationship answers from someone who knows. Yahoo! Answers - Check it out. 
http://answers.yahoo.com/dir/?link=list&sid=396545433