Yoel Marrero Calderon ycalderon
Wed Aug 9 14:43:32 PDT 2006
Hi to all . Answer or Solution to my problem :

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 ... ? 
#########################################################################
Solution :
 edit  your postgresql.conf
 then find    # - Locale and Formatting -
 change your datestyle and timezone to someone recongize to PostgresQL8.1

 for example I put this .

 datestyle = 'iso,mdy' 
 timezone = 'EST'               

restart your postgresql.
thanks to all and to God 
                            


  

-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/ms-tnef
Size: 3466 bytes
Desc: not available
Url : http://gborg.postgresql.org/pipermail/slony1-general/attachments/20060809/4c3e6c68/attachment-0001.bin



More information about the Slony1-general mailing list