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