Re: Help-PGRES_FATAL_ERROR

Jaime Casanova <jaime(at)2ndquadrant(dot)com> writes:
> On Sun, Aug 7, 2011 at 3:10 PM, John Carriel Gomez
> <john(dot)carriel(dot)g(at)gmail(dot)com> wrote:
>> Please help I can not replicate with Slony
>> ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
>> PGRES_FATAL_ERROR select "_replicaterminal".storeNode_int(1, 'Nodo
>> Maestro'); select "_replicaterminal".enableNode_int(1); - ERROR: invalid
>> input syntax for type timestamp: "Sun Aug 07 14:59:30.073665 2011 ECT"
>> CONTEXT: SQL statement "insert into "_replicaterminal".sl_confirm
>> (con_origin, con_received, con_seqno)
>> select no_id, p_no_id, 0 from
>> "_replicaterminal".sl_node
>> where no_id != p_no_id
>> and no_active"
>> PL/pgSQL function "enablenode_int" line 32 at SQL statement

> what do you have in timezone in postgresql.conf? certainly, the
> timestamp format looks odd

I think the format is OK but the receiving machine doesn't recognize
"ECT" as a timezone abbreviation. So, there's something different in
the timezone abbrevation configurations on the two machines.

regards, tom lane