MIME-Version: 1.0
Reply-To: zarkonesmall@gmail.com
From: Anatolii Smolianinov <zarkonesmall@gmail.com>
Date: Mon, 21 Oct 2024 12:01:19 +0200
Message-ID: <CABvPt_xtYyvFfyupGn=TXNGnEAFd0m_ARPFpDUWBcn603aM84w@mail.gmail.com>
Subject: Timezone: resolve $TZDIR in runtime
To: pgsql-general@lists.postgresql.org
Content-Type: multipart/alternative; boundary="000000000000a921ea0624f9bcc8"
Archived-At: <https://www.postgresql.org/message-id/CABvPt_xtYyvFfyupGn%3DTXNGnEAFd0m_ARPFpDUWBcn603aM84w%40mail.gmail.com>
Precedence: bulk

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

Hello,

I was recently working with a project which embeds postgres into
application. It uses binaries built for Debian, and configured to look for
timezones in Debian's timezone folder /usr/share/zoneinfo/, which wasn't
present on my system.

I was thinking if it's possible to redefine it in runtime, and found that
it is not possible: postgres support either compilation flag
--with-system-tzdata or built-in tz file --  timezone/data/tzdata.zi. From
the other hand, looking at src/timezone/pgtz.c#L54, it seems that timezone
dir resolve happens in runtime, which means, it is possible to use $TZDIR
environment variable or configuration option to achieve this without
recompilation.

Do you think it is a feasible thing to do? it would be very convenient for
portable postgers builds.

Thanks!

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

<div dir=3D"ltr"><div>Hello, <br></div><div><br></div><div>I was recently w=
orking with a project which embeds postgres into application. It uses binar=
ies built for Debian, and configured to look for timezones in Debian&#39;s =
timezone folder /usr/share/zoneinfo/, which wasn&#39;t present on my system=
.<br></div><div><br></div><div>I was thinking if it&#39;s possible to redef=
ine it in runtime, and found that it is not possible: postgres support eith=
er compilation flag --with-system-tzdata or built-in tz file --=C2=A0 timez=
one/data/tzdata.zi. From the other hand, looking at src/timezone/pgtz.c#L54=
, it seems that timezone dir resolve happens in runtime, which means, it is=
 possible to use $TZDIR environment variable or configuration option to ach=
ieve this without recompilation. <br></div><div><br></div><div>Do you think=
 it is a feasible thing to do? it would be very convenient for portable pos=
tgers builds. <br></div><div><br></div><div>Thanks!<br></div></div>

--000000000000a921ea0624f9bcc8--