Wed Aug 9 14:43:32 PDT 2006
- Previous message: [Slony1-general] Enabling and disabling triggers
- Next message: [Slony1-general] replicate part of information inside one table ?
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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
- Previous message: [Slony1-general] Enabling and disabling triggers
- Next message: [Slony1-general] replicate part of information inside one table ?
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list