Hi!

Many thanks. Now my script worked.

This was my solution:

TZ='America/Argentina/Mendoza'
export TZ
PGTZ='America/Argentina/Mendoza'
export PGTZ

and then: ./cluster_setup.sh

Without errors. So it wasn't necesary to put them to GMT. I put it into
/etc/profile so I think they will be initialized on any startup...

Sebastian



----- Original Message ----- 
From: "Christopher Browne" <cbbrowne at ca.afilias.info>
To: "Sebastian K?hner" <skuehner at veraza.com>
Cc: <slony1-general at gborg.postgresql.org>
Sent: Tuesday, September 06, 2005 3:00 PM
Subject: Re: [Slony1-general] timestamp


> Sebastian K?hner wrote:
>
> >...and following error message occurs:
> >
> >ERROR:  invalid input syntax for type timestamp: "Tue Sep 06
02:23:17.284444
> >2005 Local time zone must be set--see zic manual page"
> >CONTEXT:  SQL statement "insert into "_sql_cluster6".sl_confirm
(con_origin,
> >con_received, con_seqno) select no_id,  $1 , 0 from
"_sql_cluster6".sl_node
> >where no_id !=  $2  and no_active"
> >        PL/pgSQL function "enablenode_int" line 32 at SQL statement
> >
> >
> >I don't have any idea why. Anyone of you can help me? How do I use ZIC
(man
> >zic doesn't say me anything)?
> >
> >
> I'm not sure what flavour of Unix you're on; what is seemingly happening
> here is that there is some confusion as to what timezone you're in.
>
> The "best practice" that we have found has been to set PGTZ and TZ to
> either GMT or UTC; it seems clear that that is NOT what you're using.
>
> This isn't a Slony-I problem per se; you'll find it the case any time
> you grab a timestamp via current_timestamp if you're using a timezone
> that PostgreSQL doesn't recognize.
>