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

 
---------------------------------
TV dinner still cooling?
Check out "Tonight's Picks" on Yahoo! TV.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20070708/5ce6b5ca/attachment.htm