----------------------------------------------------------------------------------------------------------- > but when I run the script out me this ERROR : > > [EMAIL PROTECTED] /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 _______________________________________________ Slony1-general mailing list [email protected] http://gborg.postgresql.org/mailman/listinfo/slony1-general
