Re: pgsql: Update time zone data files to tzdata release 2024b.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Andrew Dunstan <andrew(at)dunslane(dot)net>
Cc: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: Re: pgsql: Update time zone data files to tzdata release 2024b.
Date: 2024-10-30 23:20:05
Message-ID: 904934.1730330405@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

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.

regards, tom lane

In response to

Browse pgsql-committers by date

  From Date Subject
Next Message Michael Paquier 2024-10-30 23:43:40 pgsql: injection_points: Improve comment about disabled isolation permu
Previous Message Tom Lane 2024-10-30 23:07:56 Re: pgsql: Update time zone data files to tzdata release 2024b.