| Stéphane Pétrot 2005-06-15, 7:24 am |
| 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=$MASTERDBNAM
E host=$MLOCALE
user=$REPLICATIONUSE
R';
#node @obelix_node admin conninfo = 'dbname=$SLAVEDBNAME
host=$MDISTANTE
user=$REPLICATIONUSE
R';
node 3 admin conninfo = 'dbname=$SLAVEDBNAME
host=$MDISTANTE2
user=$REPLICATIONUSE
R';
# ----
# 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 :
[color=darkred]
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
|