Re: Timezone: resolve $TZDIR in runtime

2024-10-21 Thread Anatolii Smolianinov
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

Re: Timezone: resolve $TZDIR in runtime

2024-10-21 Thread Tom Lane
Anatolii Smolianinov 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

Re: Timezone: resolve $TZDIR in runtime

2024-10-21 Thread Gianni Ceccarelli
On 2024-10-21 Anatolii Smolianinov wrote: > date(1) does not set timezone dir: but it uses TZ, and, in man, it > refers to tzselect: > > use tzselect to find TZ" That's an imperative "use", not an indicative. In other words: the user, to find an appropriate value for `TZ`, should run the command

Re: Timezone: resolve $TZDIR in runtime

2024-10-21 Thread Anatolii Smolianinov
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/ date(1) does not set timezone dir: but it uses TZ, and, in man, it refers to tzselect: > use tzselect to find TZ" On Mon, Oct 21, 2024 at 6:16 P

Re: Timezone: resolve $TZDIR in runtime

2024-10-21 Thread Tom Lane
Anatolii Smolianinov writes: > As I've mentioned, it's not about embedded really, it is more about support > of standard $TZDIR mechanics in general. One problem with your argument is that there's no standard mentioning TZDIR, nor does it appear to affect actually-standard utilities like date(1).

Re: Timezone: resolve $TZDIR in runtime

2024-10-21 Thread Anatolii Smolianinov
Hi Adrian! Totally agree. I think embedded postgresql appeared mainly because of compatibility reasons. If you are using postgres on server, with some of the custom features which you can't find in other databases, and want to enable "local mod" for your users, (and also for tests maybe), but you

Re: Timezone: resolve $TZDIR in runtime

2024-10-21 Thread Adrian Klaver
On 10/21/24 08:03, Anatolii Smolianinov wrote: Hi Tom, thanks for your reply! I understand your point, and also, the idea of embedding postgresql -- it might be just not what postgresql is built for. I was just thinking that respecting the standard TZDIR approach would add more flexibility.

Re: Timezone: resolve $TZDIR in runtime

2024-10-21 Thread Anatolii Smolianinov
Hi Tom, thanks for your reply! I understand your point, and also, the idea of embedding postgresql -- it might be just not what postgresql is built for. I was just thinking that respecting the standard TZDIR approach would add more flexibility. If you have 5 linux distros and everyone has a diffe

Re: Timezone: resolve $TZDIR in runtime

2024-10-21 Thread Tom Lane
Anatolii Smolianinov 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