Re: BUG #16404: PostgreSQL 12.2: Database restore does not accept the EEST time zone.
| От | Tom Lane |
|---|---|
| Тема | Re: BUG #16404: PostgreSQL 12.2: Database restore does not accept the EEST time zone. |
| Дата | |
| Msg-id | 21109.1588255724@sss.pgh.pa.us обсуждение исходный текст |
| Ответ на | BUG #16404: PostgreSQL 12.2: Database restore does not accept the EEST time zone. (PG Bug reporting form <noreply@postgresql.org>) |
| Ответы |
VS: BUG #16404: PostgreSQL 12.2: Database restore does not accept theEEST time zone.
|
| Список | 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 по дате отправления: