Wed Aug 16 01:50:08 PDT 2006
- Previous message: [Slony1-general] O/S Patch for post-1.2 - removing sl_node.no_spool
- Next message: [Slony1-general] RC3 failure to init cluster -- timezone issue?
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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
- Previous message: [Slony1-general] O/S Patch for post-1.2 - removing sl_node.no_spool
- Next message: [Slony1-general] RC3 failure to init cluster -- timezone issue?
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list