Postgres Pro
Downloads
Home   >   mailing lists

Re: Timezone: resolve $TZDIR in runtime - Mailing list pgsql-general

From Anatolii Smolianinov
Subject Re: Timezone: resolve $TZDIR in runtime
Date
Msg-id CABvPt_z6YG9O2JEVpS30L80=MmH-dwe_B119Lt4xzUcU9rb2eQ@mail.gmail.com
Whole thread Raw
In response to Re: Timezone: resolve $TZDIR in runtime  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view
Ah, I see -- so tzselect uses tzdb distribution too? it is just, tzselect can alter the timezone database and it looks for TZDIR in some distributions, however, it is not the source of truth in that sense. I think I see now why it's not really feasible to make such an adjustment..

Thanks for your help!

On Mon, Oct 21, 2024 at 7:59 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
Anatolii Smolianinov <zarkonesmall@gmail.com> writes:
> Right, it is not an official standard, but TZDIR appears in tzselect, which
> comes from GNU libc.  https://www.unix.com/man-page/redhat/8/TZSELECT/

No, it comes from the tzdb distribution, which otherwise hard-wires
a compile-time choice for that directory.  Which is how come no other
program responds to that environment variable.  So if anything, that's
precedent for our behavior.

                        regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Timezone: resolve $TZDIR in runtime
Next
From: Adrian Klaver
Date:
Subject: Re: Fwd: Postgres attach partition: AccessExclusive lock set on different tables depending on how attaching is performed