Hi,


I would like to get a help concerning an error message that I always get!
It is the following :
> ERROR: no admin conninfo for node 134589040

My Slony-I test environment is the following. My MasterDB : pgbenchdb1 
(ip : localhost)
SlaveDB : pgbenchdb2 (ip : 192.168.1.24)
Slony_user : slonyuser
PGBENCH_user : pgbenchuser

I am using pgSQL 7.4.7 on debian.
I followed the standard steps written in every pg-Forum to initiate, 
start, prepare and test a database.
I edited the following Script and run it only from the master machine. I 
get (everytime the following message :
ERROR: no admin conninfo for node 134589040 ).

Is it right that ? I must run it from the master machine, or do I have 
to run it from Master and than do the same thing from a slave machine.

PLEASE HELP ME beacuse I am investing a lot of time analysing the errors 
without results.
The script I run on the  master is the following:

Thanks a lot
<LARGO>
------------------------------------------------------------------------------------------------------- 

#!/bin/sh

#CLUSTER=testcluster1
#DBNAME1=pgbenchdb1
#DBNAME2=pgbenchdb2
#HOST1=localhost
#HOST2=192.168.1.24
#SLONY_USER=slonyuser
#PGBENCH_USER=pgbenchuser

slonik <<_EOF_

CLUSTER NAME=testcluster1;

NODE 1 ADMIN CONNINFO='dbname=pgbenchdb1 host=localhost user=slonyuser';
NODE 2 ADMIN CONNINFO='dbname=pgbenchdb2 host=192.168.1.24 user=slonyuser';

TRY
{
INIT CLUSTER ( ID=1, COMMENT='Node 1' );
TABLE ADD KEY ( NODE ID=1, FULLY QUALIFIED NAME='public.history' );
## These 2 commands are not executed PROPERLY

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=pgbenchdb1 
host=localhost user=slonyuser');
STORE PATH ( SERVER=2,CLIENT=1,CONNINFO='dbname=pgbenchdb2 
host=192.168.1.24 user=slonyuser');

STORE LISTEN ( ORIGIN=1,PROVIDER=1,RECEIVER=2 );
STORE LISTEN ( ORIGIN=2,PROVIDER=2,RECEIVER=1 );
}

ON ERROR { ECHO 'NOTHING HAS WORKED'; }
ON SUCCESS { ECHO 'EVERYTHING WAS OK'; }

_EOF_