MIME-Version: 1.0
References: 
 <CAG=EN52H87=Cpe_cuLADfow6SmVc7LD6Cyfr+9FDb6zxs7Bx6w@mail.gmail.com>
 <CAOMoQbSWENcLg378jNs=Q7yZnmGcg0O9j2sfB85isWMfseGWMA@mail.gmail.com>
In-Reply-To: 
 <CAOMoQbSWENcLg378jNs=Q7yZnmGcg0O9j2sfB85isWMfseGWMA@mail.gmail.com>
From: Creston Jamison <creston.jamison@gmail.com>
Date: Mon, 16 Sep 2024 14:46:50 -0400
Message-ID: 
 <CAG=EN52cSueFDu=39F3bmpaiX9LksAE19L=LykBwSmmR3FZFFg@mail.gmail.com>
Subject: Re: Ubuntu 24.04 Time Zone Issue?
To: Bradford Boyle <bradford.d.boyle@gmail.com>
Cc: pgsql-pkg-debian@postgresql.org
Content-Type: multipart/alternative; boundary="000000000000912f2f062240ff8e"
Archived-At: 
 <https://www.postgresql.org/message-id/CAG%3DEN52cSueFDu%3D39F3bmpaiX9LksAE19L%3DLykBwSmmR3FZFFg%40mail.gmail.com>
Precedence: bulk

--000000000000912f2f062240ff8e
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Thanks! I dug into this a bit more as other time zones like "US/Pacific"
were also affected.

This appears related to this Ubuntu 24.04 change:
https://discourse.ubuntu.com/t/ubuntu-24-04-lts-noble-numbat-release-notes/=
39890#tzdata-package-split

It looks like Ubuntu 24.04 no longer includes "legacy" time zones by
default. However, I was able to add them back by installing the
tzdata-legacy package with

sudo apt install tzdata-legacy

After installing, Postgres correctly recognized things like "US/Pacific"
and "Asia/Saigon" again.

Many thanks,
Creston

On Mon, Sep 16, 2024 at 12:22=E2=80=AFAM Bradford Boyle <bradford.d.boyle@g=
mail.com>
wrote:

> Hi Creston,
>
> It looks like older versions of the tzdata package included a link
> from Asia/Saigon to Asia/Ho_Chi_Minh. The link is present in
> 2024a-0ubuntu0.22.04.1 (Jammy) but has been removed in
> 2024a-3ubuntu1.1 (Noble).
>
> -- Bradford
>

--000000000000912f2f062240ff8e
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div><div>Thanks! I dug into this a bit more as other time=
 zones like &quot;US/Pacific&quot; were also affected.<br><br>This appears =
related to this Ubuntu 24.04 change: <a href=3D"https://discourse.ubuntu.co=
m/t/ubuntu-24-04-lts-noble-numbat-release-notes/39890#tzdata-package-split"=
>https://discourse.ubuntu.com/t/ubuntu-24-04-lts-noble-numbat-release-notes=
/39890#tzdata-package-split</a><br><br></div>It looks like Ubuntu 24.04 no =
longer includes &quot;legacy&quot; time zones by default. However, I was ab=
le to add them back by installing the tzdata-legacy package with<br><br><sp=
an style=3D"font-family:monospace">sudo apt install tzdata-legacy</span><br=
></div><div><br></div><div>After installing, Postgres correctly recognized =
things like &quot;US/Pacific&quot; and &quot;Asia/Saigon&quot; again.<br></=
div><div><br></div><div>Many thanks,</div><div>Creston<br></div></div><br><=
div class=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail_attr">On Mon, Sep=
 16, 2024 at 12:22=E2=80=AFAM Bradford Boyle &lt;<a href=3D"mailto:bradford=
.d.boyle@gmail.com">bradford.d.boyle@gmail.com</a>&gt; wrote:<br></div><blo=
ckquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left=
:1px solid rgb(204,204,204);padding-left:1ex">Hi Creston,<br>
<br>
It looks like older versions of the tzdata package included a link<br>
from Asia/Saigon to Asia/Ho_Chi_Minh. The link is present in<br>
2024a-0ubuntu0.22.04.1 (Jammy) but has been removed in<br>
2024a-3ubuntu1.1 (Noble).<br>
<br>
-- Bradford<br>
</blockquote></div>

--000000000000912f2f062240ff8e--