this is an example of may master_script cofiguration :
 
---------------------------------------------------------------------------------------
#!/bin/bash

CLUSTERNAME=cluster1
MASTERDBNAME=master
SLAVEDBNAME=slave
MASTERHOST=10.33.13.2
SLAVEHOST=10.33.13.1
REPLICATIONUSER=replication
SLAVEUSER=replication
slonik << _EOF_

cluster name=$CLUSTERNAME;

node 1 admin conninfo = 'dbname=$MASTERDBNAME host=$MASTERHOST user=$REPLICATIONUSER ';
node 2 admin conninfo = 'dbname=$SLAVEDBNAME host=$SLAVEHOST user=$SLAVEUSER ';  

init cluster (id=1, comment = 'Master Node');

create set ( id=1, origin=1,comment= 'All tables');

set add table (set id=1, origin=1, id=1, fully qualified name = 'public.estudiantes', comment='table');
set add table (set id=1, origin=1, id=2, fully qualified name = 'public.profesores', comment = 'table');

store node (id=2, comment ='Slave node');
store path (server = 1, client = 2, conninfo='dbname=$MASTERDBNAME host=$MASTERHOST user=$REPLICATIONUSER ');
store path (server = 2, client = 1, conninfo='dbname=$SLAVEDBNAME host=$SLAVEHOST user=$SLAVEUSER ');
store listen (origin=1, provider = 1, receiver=2);
store listen (origin=2, provider = 2, receiver=1);
_EOF_

-----------------------------------------------------------------------------------------------------------
but when I run the script out me this ERROR :

root at boanerges /usr/src $ ./slon_master
<stdin>:23: PGRES_FATAL_ERROR select "_cluster1".storeNode_int(1, 'Master Node', 'f'); select   "_cluster1".enableNode_int(1);  - ERROR:  la sintaxis de entrada no es v?lida para el tipo timestamp: <<Mon Aug 07 09:08:13.471350 2006 Local time zone must be set--see zic manual page>>
CONTEXT:  sentencia SQL: <<insert into "_cluster1".sl_confirm (con_origin, con_received, con_seqno) select no_id,  $1 , 0 from "_cluster1".sl_node where no_id !=  $1  and no_active>>
PL/pgSQL function "enablenode_int" line 32 at SQL statement

Someone of you know the solution for this ... ? 
thanks



-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/ms-tnef
Size: 3638 bytes
Desc: not available
Url : http://gborg.postgresql.org/pipermail/slony1-general/attachments/20060807/846a5670/attachment.bin