[Slony1-general] Timezone issue Asia/Jakarta

[Steve Singer]

On Fri, 19 Jul 2024, Sung Hsin Lei via Slony1-general wrote:


When I try that locally into a table without slony I get the error

~~~
create temp table c (a timestamptz);
CREATE TABLE
template1=# insert into c values('Fri July 19 12:48:20.754251 2024 WIB');
ERROR:  invalid input syntax for type timestamp with time zone: "Fri July 19 
12:48:20.754251 2024 WIB"
~~~

Have you tried running slon with a different timezone?

Maybe
export TZ=UTC
into the environment before starting slon(though I haven't tried this)

Steve



> Has anyone experienced a timezone issue with Asia/Jakarta?
> I'm getting an "Invalid input syntax for type timestamp with time zone" when slony inserts into sl_confirm table. Apparently,
> it does not like the WIB in "Fri July 19 12:48:20.754251 2024 WIB"
> 
> Any way of getting around this without changing the timezone in Postgres?
> 
> 
> Thanks.
> 
> Sung Hsin
> 
> 
> 
>