MIME-Version: 1.0
From: Creston Jamison <creston.jamison@gmail.com>
Date: Sat, 14 Sep 2024 11:16:17 -0400
Message-ID: 
 <CAG=EN52H87=Cpe_cuLADfow6SmVc7LD6Cyfr+9FDb6zxs7Bx6w@mail.gmail.com>
Subject: Ubuntu 24.04 Time Zone Issue?
To: pgsql-pkg-debian@postgresql.org
Content-Type: multipart/alternative; boundary="000000000000e5a014062215d2f8"
Archived-At: 
 <https://www.postgresql.org/message-id/CAG%3DEN52H87%3DCpe_cuLADfow6SmVc7LD6Cyfr%2B9FDb6zxs7Bx6w%40mail.gmail.com>
Precedence: bulk

--000000000000e5a014062215d2f8
Content-Type: text/plain; charset="UTF-8"

A few months ago, I installed Ubuntu 24.04 on a local system and then
installed PostgreSQL 16 following the manual installation method using apt.
Everything installed successfully. However, recently, when trying to work
with time zones, I am receiving an error:

postgres=# select now() at time zone 'Asia/Saigon';
ERROR:  time zone "Asia/Saigon" not recognized

I do not get this error on any Ubuntu 22.04 install I tested.

I tried an AWS EC2 instance of Ubuntu 24.04 and this query works
successfully.
I tried a Hetzner server of Ubuntu 24.04 and it does not work.

Could there be some package dependency that is missing on Ubuntu 24.04 for
time zone support? I am not quite sure of the next steps to take.

Here is the /var/log/apt/history.log from the install on Hetzner

Start-Date: 2024-09-14  14:42:31
Commandline: apt -y install postgresql-16
Install: libtypes-serialiser-perl:amd64 (1.01-1, automatic), ssl-cert:amd64
(1.1.2ubuntu1, automatic), postgresql-16:amd64 (16.4-1.pgdg24.04+1),
libjson-perl:amd64 (4.10000-1, automatic), postgresql-client-16:amd64
(16.4-1.pgdg24.04+1, automatic), libcommon-sense-perl:amd64 (3.75-3build3,
automatic), libllvm17t64:amd64 (1:17.0.6-9ubuntu1, automatic),
postgresql-common:amd64 (262.pgdg24.04+1, automatic),
postgresql-client-commo
n:amd64 (262.pgdg24.04+1, automatic), libjson-xs-perl:amd64 (4.030-2build3,
automatic), libpq5:amd64 (16.4-1.pgdg24.04+1, automatic)
End-Date: 2024-09-14  14:42:43

Many thanks,
Creston

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

<div dir=3D"ltr"><div>A few months ago, I installed Ubuntu 24.04 on a local=
 system and then installed PostgreSQL 16 following the manual installation =
method using apt. Everything installed successfully. However, recently, whe=
n trying to work with time zones, I am receiving an error:</div><div><br></=
div><div>postgres=3D# select now() at time zone &#39;Asia/Saigon&#39;;<br>E=
RROR: =C2=A0time zone &quot;Asia/Saigon&quot; not recognized</div><div><br>=
</div><div>I do not get this error on any Ubuntu 22.04 install I tested.<br=
></div><div><br></div><div>I tried an AWS EC2 instance of Ubuntu 24.04 and =
this query works successfully.</div><div>I tried a Hetzner server of Ubuntu=
 24.04 and it does not work.</div><div><br></div><div>Could there be some p=
ackage dependency that is missing on Ubuntu 24.04 for time zone support? I =
am not quite sure of the next steps to take.<br></div><div><br></div><div>H=
ere is the /var/log/apt/history.log from the install on Hetzner<br></div><d=
iv><br></div><div>Start-Date: 2024-09-14 =C2=A014:42:31<br>Commandline: apt=
 -y install postgresql-16<br>Install: libtypes-serialiser-perl:amd64 (1.01-=
1, automatic), ssl-cert:amd64 (1.1.2ubuntu1, automatic), postgresql-16:amd6=
4 (16.4-1.pgdg24.04+1), libjson-perl:amd64 (4.10000-1, automatic), postgres=
ql-client-16:amd64 <br>(16.4-1.pgdg24.04+1, automatic), libcommon-sense-per=
l:amd64 (3.75-3build3, automatic), libllvm17t64:amd64 (1:17.0.6-9ubuntu1, a=
utomatic), postgresql-common:amd64 (262.pgdg24.04+1, automatic), postgresql=
-client-commo<br>n:amd64 (262.pgdg24.04+1, automatic), libjson-xs-perl:amd6=
4 (4.030-2build3, automatic), libpq5:amd64 (16.4-1.pgdg24.04+1, automatic)<=
br>End-Date: 2024-09-14 =C2=A014:42:43<br></div><div><br></div><div>Many th=
anks,</div><div>Creston<br></div></div>

--000000000000e5a014062215d2f8--