Re: pgsql: Update time zone data files to tzdata release 2024b.
От | Andrew Dunstan |
---|---|
Тема | Re: pgsql: Update time zone data files to tzdata release 2024b. |
Дата | |
Msg-id | CAD5tBc+gN9un33frn6x3AN3TeFaRkYmRw-oEFtoxJVUB8v2HVA@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: pgsql: Update time zone data files to tzdata release 2024b. (Tom Lane <tgl@sss.pgh.pa.us>) |
Список | pgsql-committers |
On Wed, Oct 30, 2024 at 7:20 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
I wrote:
> So the problem is precisely that *our* interpretation of EST5EDT
> changed when we adopted tzdata 2024b, and that is affecting how
> we dump these old timestamps. Or at least, that seems like what
> should be happening, but then why is only crake showing a failure?
Oh, got it: of the machines in question, only crake is selecting
EST5EDT as default timezone. I can see from the buildfarm logs
that drongo and fairywren are using UTC, and as said, my test
instance is selecting America/New_York. Both UTC and America/New_York
would have rendered these old timestamps the same way all along,
but EST5EDT just changed its interpretation of them.
That means that simply forcing a re-run of the old branches on
crake won't fix it, because pre-v12 branches will still think
that EST5EDT means what it used to. We need to make sure that
the dumps are taken in a completely stable zone, i.e. UTC.
Yep, I rebuilt all those old branches using 'America/New_York" and we're back to green. Thanks for the diagnosis.
cheers
andrew
В списке pgsql-committers по дате отправления: