agora inbox for pgsql-committers@postgresql.org
help / color / mirror / Atom feedFrom: Tom Lane <tgl@sss.pgh.pa.us>
To: Andrew Dunstan <andrew@dunslane.net>
Cc: pgsql-committers@lists.postgresql.org
Subject: Re: pgsql: Update time zone data files to tzdata release 2024b.
Date: Wed, 30 Oct 2024 19:20:05 -0400
Message-ID: <904934.1730330405@sss.pgh.pa.us> (raw)
In-Reply-To: <871448.1730329676@sss.pgh.pa.us>
References: <362289.1730241666@sss.pgh.pa.us>
<55A5E01C-1B0F-40F9-94EA-FEDED1575C92@dunslane.net>
<595311.1730300440@sss.pgh.pa.us>
<CAD5tBcLHz6NLCW_65qYka08HRVeT6w15Cd1YFKmHV5Ou43Fu4g@mail.gmail.com>
<764322.1730320400@sss.pgh.pa.us>
<CAD5tBcLetMh6sG0SpDB4fPTFDt37=_q_nq3eOExQPK6qHOgnQA@mail.gmail.com>
<CAD5tBcJC8tuSAzC7b5GdGv0p8O9d1tziHoD01aW8F_WmVj11aw@mail.gmail.com>
<868637.1730328216@sss.pgh.pa.us>
<871448.1730329676@sss.pgh.pa.us>
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
view thread (377+ messages) latest in thread
Message-ID: <904934.1730330405@sss.pgh.pa.us>
Permalink: ../904934.1730330405@sss.pgh.pa.us/
Also on: postgresql.org/message-id/904934.1730330405@sss.pgh.pa.us
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-committers@postgresql.org
Cc: tgl@sss.pgh.pa.us, andrew@dunslane.net, pgsql-committers@lists.postgresql.org
Subject: Re: pgsql: Update time zone data files to tzdata release 2024b.
In-Reply-To: <904934.1730330405@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox