Hello,

I use the following script to setup a cluster:

#!/bin/sh
CLUSTER=sql_cluster6
DB1=contactdb
DB2=contactdb_slave
H1=localhost
H2=localhost
U=postgres
slonik <<_EOF_
cluster name = $CLUSTER;
node 1 admin conninfo = 'dbname=$DB1 host=$H1 user=$U';
node 2 admin conninfo = 'dbname=$DB2 host=$H2 user=$U';
init cluster (id = 1, comment = 'Node 1');
create set (id = 1, origin = 1,
    comment = 'contact table');
set add table (set id = 1, origin = 1, id = 1,
    full qualified name = 'public.contact',
    comment = 'Table contact');
set add sequence (set id = 1, origin = 1, id = 2,
    full qualified name = 'public.contact_seq',
    comment = 'Sequence contact_seq');
store node (id = 2, comment = 'Node 2');
store path (server = 1, client = 2,
    conninfo = 'dbname=$DB1 host=$H1 user=$U');
store path (server = 2, client = 1,
    conninfo = 'dbname=$DB2 host=$H2 user=$U');
store listen (origin = 1, provider = 1, receiver = 2);
store listen (origin = 2, provider = 2, receiver = 1);



...and following error message occurs:

ERROR:  invalid input syntax for type timestamp: "Tue Sep 06 02:23:17.284444
2005 Local time zone must be set--see zic manual page"
CONTEXT:  SQL statement "insert into "_sql_cluster6".sl_confirm (con_origin,
con_received, con_seqno) select no_id,  $1 , 0 from "_sql_cluster6".sl_node
where no_id !=  $2  and no_active"
        PL/pgSQL function "enablenode_int" line 32 at SQL statement


I don't have any idea why. Anyone of you can help me? How do I use ZIC (man
zic doesn't say me anything)?

Many thanks!

Sebastian