From: Tom Lane <tgl@sss.pgh.pa.us>
To: zarkonesmall@gmail.com
cc: pgsql-general@lists.postgresql.org
Subject: Re: Timezone: resolve $TZDIR in runtime
In-reply-to: <CABvPt_xtYyvFfyupGn=TXNGnEAFd0m_ARPFpDUWBcn603aM84w@mail.gmail.com>
References: <CABvPt_xtYyvFfyupGn=TXNGnEAFd0m_ARPFpDUWBcn603aM84w@mail.gmail.com>
Comments: In-reply-to Anatolii Smolianinov <zarkonesmall@gmail.com>
	message dated "Mon, 21 Oct 2024 12:01:19 +0200"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <1554255.1729521467.1@sss.pgh.pa.us>
Date: Mon, 21 Oct 2024 10:37:47 -0400
Message-ID: <1554256.1729521467@sss.pgh.pa.us>
Archived-At: <https://www.postgresql.org/message-id/1554256.1729521467%40sss.pgh.pa.us>
Precedence: bulk

Anatolii Smolianinov <zarkonesmall@gmail.com> writes:
> 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.

Why are you trying to use binaries built for Debian on some other
platform?  Seems like there'd be more problems than just timezones.

> 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.

I'm pretty down on this idea because it adds complexity, ie ways to
break things.  If you want a more self-contained installation, you
could build it without specifying --with-system-tzdata.

			regards, tom lane