Mon Aug 7 11:31:53 PDT 2006
- Previous message: [Slony1-general] Problem starting master_server_script
- Next message: [Slony1-general] Speeding through a backlog
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
----------------------------------------------------------------------------------------------------------- > 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
- Previous message: [Slony1-general] Problem starting master_server_script
- Next message: [Slony1-general] Speeding through a backlog
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list