Julian Scarfe julian
Wed Aug 16 01:50:08 PDT 2006
I've uninstalled all nodes from my previous cluster (tested using 1.1.5).

After installation of 1.2RC3 software, using the same initialization script
as was successful before, I now get:

install/install_nodes_1_and_2.slonik:6: PGRES_FATAL_ERROR select
"_T1".storeNode_int(1, 'Node 1', 'f'); select "_T1".enableNode_int(1);  -
ERROR:  invalid input syntax for type timestamp: "Wed Aug 16 08:11:23.699244
2006 UCT"
CONTEXT:  SQL statement "insert into "_T1".sl_confirm (con_origin,
con_received, con_seqno) select no_id,  $1 , 0 from "_T1".sl_node where
no_id !=  $1  and no_active"
PL/pgSQL function "enablenode_int" line 32 at SQL statement

The failure appears to occur at the store node command in my initiatlization
script
-------
#!/usr/lib/postgresql/8.1/bin/slonik

include </path/to/common.slonik>;

init cluster (id = 1, comment = 'Node 1');
store node (id = 2, comment = 'Node 2');

...
-------

The timezone on our boxes is set as Etc/UCT.

=> select to_char(current_timestamp, 'HH12:MI:SS TZ');
   to_char
--------------
 08:46:20 UCT

However "UCT" is not a valid input format:

=> select '08:46:20 UCT'::time;
ERROR:  invalid input syntax for type time: "08:46:20 UCT"

Is there perhaps an assumption somewhere that what comes out is valid to go 
back in?

Julian





More information about the Slony1-general mailing list