cbbrowne at ca.afilias.info cbbrowne
Mon Aug 7 11:31:53 PDT 2006
-----------------------------------------------------------------------------------------------------------
> 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

This looks like a problem that falls out of not using a time zone that
PostgreSQL recognizes.

We resolve this on our systems by setting environment variables TZ and
PGTZ to either UTC or GMT in our environments.  UTC and GMT are sure to be
supported; it sounds as though the timezone you're using isn't.

http://gborg.postgresql.org/project/slony1/bugs/bugupdate.php?1200
http://cbbrowne.com/info/requirements.html




More information about the Slony1-general mailing list