Hello,

I have run once the slony_setup.sh script that configures nodes. For me it 
looks like (the begining of script):

#!/bin/sh

PGBINDIR=/usr/lib/postgresql /bin
export PGBINDIR
PATH="$PGBINDIR:$PATH"
export PATH

slonik <<_EOF_
# ----
define asterix_node 1;
define obelix_node 2;
define idefix_node 3;

# ----
# This defines which namespace the replication system uses
# ----
cluster name = $CLUSTERNAME;

# ----
# Admin conninfo's are used by the slonik program to connect
# to the node databases. So these are the PQconnectdb arguments
# that connect from the administrators workstation (where
# slonik is executed).
# first drop the create nodes
# ----
#drop node ( id = @asterix_node);
#drop node (id = @obelix_node);
#drop node (id = @idefix_node);
node 1 admin conninfo = 'dbname=$MASTERDBNAME host=$MLOCALE 
user=$REPLICATIONUSER';
#node @obelix_node admin conninfo = 'dbname=$SLAVEDBNAME host=$MDISTANTE 
user=$REPLICATIONUSER';
node 3 admin conninfo = 'dbname=$SLAVEDBNAME host=$MDISTANTE2 
user=$REPLICATIONUSER';

# ----
# Initialize the first node. The id must be 1.
# This creates the schema "_test1" containing all replication
# system specific database objects.
# ----
init cluster ( id = @asterix_node, comment = 'Master Node 1' );
[...]


Then I had an error about primary_key that was not found. After making 
correction, I try to run the script again, but I got the error :

>> namespace "_cluster" already exists in database of node 1

Then I have commented out the line init cluster ( id = @asterix_node, 
comment = 'Master Node 1' ); and add the lines "drop node 
(id=@asterix_node);..." but I got another error : <stdin>:18: ERROR: syntax 
error at or near drop

Could you please tell me how to re-initialize the whole process (cluster, 
node definitions, etc...) ? I was looking for some tables dealing about 
slony (table like sl_node) but I was not able to find it. Where are they?

Thanks...
St?phane
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://gborg.postgresql.org/pipermail/slony1-general/attachments/20050615/25a8efd6/attachment-0001.html