Re: BUG #16404: PostgreSQL 12.2: Database restore does not accept the EEST time zone. - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #16404: PostgreSQL 12.2: Database restore does not accept the EEST time zone.
Date
Msg-id 21109.1588255724@sss.pgh.pa.us
Whole thread Raw
In response to BUG #16404: PostgreSQL 12.2: Database restore does not accept the EEST time zone.  (PG Bug reporting form <noreply@postgresql.org>)
Responses VS: BUG #16404: PostgreSQL 12.2: Database restore does not accept theEEST time zone.
List pgsql-bugs
PG Bug reporting form <noreply@postgresql.org> writes:
> Database restore does not accept the EEST time zone. PostgreSQL version 10
> restore accept EEST timezone.

Works for me:

# select '2020-04-30 10:01:32.277852 EEST'::timestamptz;
          timestamptz          
-------------------------------
 2020-04-30 03:01:32.277852-04
(1 row)

Maybe you are using a non-default timezone_abbreviations file? [1]

In any case, it's not very clear why this would be a database
restore issue.  Dump/restore should always use numeric UTC
offsets in dumped timestamps.

Anyway, you'll need to provide a lot more detail if you want
help on this.

            regards, tom lane

[1] https://www.postgresql.org/docs/current/datetime-config-files.html



pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #16403: set_bit function does not have expected effect
Next
From: "断桥烟雨三两月"
Date:
Subject: 回复: report bug