Re: Timezone: resolve $TZDIR in runtime

2024-10-21 Thread Anatolii Smolianinov
your help! On Mon, Oct 21, 2024 at 7:59 PM Tom Lane wrote: > 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

Re: Timezone: resolve $TZDIR in runtime

2024-10-21 Thread Anatolii Smolianinov
024 at 6:16 PM Tom Lane wrote: > 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

Re: Timezone: resolve $TZDIR in runtime

2024-10-21 Thread Anatolii Smolianinov
2024 at 5:53 PM Adrian Klaver wrote: > 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

Re: Timezone: resolve $TZDIR in runtime

2024-10-21 Thread Anatolii Smolianinov
standard way of timezone configuration would improve the experience of using postgresql in general and make it more predictive. Maybe it's not true though due to legacy reasons though -- old users just wouldn't expect $TZDIR to alter the configuration. On Mon, Oct 21, 2024 at 4:37 PM Tom L

Timezone: resolve $TZDIR in runtime

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