Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1t2vn3-008gk4-FL for pgsql-general@arkaria.postgresql.org; Mon, 21 Oct 2024 17:01:57 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1t2vn0-009ZAt-KF for pgsql-general@arkaria.postgresql.org; Mon, 21 Oct 2024 17:01:54 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1t2vn0-009ZAb-92 for pgsql-general@lists.postgresql.org; Mon, 21 Oct 2024 17:01:54 +0000 Received: from mail-lf1-x135.google.com ([2a00:1450:4864:20::135]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1t2vmx-0022aV-Vo for pgsql-general@lists.postgresql.org; Mon, 21 Oct 2024 17:01:53 +0000 Received: by mail-lf1-x135.google.com with SMTP id 2adb3069b0e04-539f6e1f756so5488058e87.0 for ; Mon, 21 Oct 2024 10:01:51 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1729530110; x=1730134910; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:reply-to:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=bqlzZ4m4X9RjL4yuSJpIpxBzp3UyScneM7XabjUeZtc=; b=ZJ+HQs/Dmfi83qcu/86NQLTyZoaKwfx+AOCgCYjvwyIY8zhY0BVSEVB4qv4UWC1K/a +pYo05cuF4MWVX6PfAu4/XOCjakR+AC/BtdDy3n08L48vUaKZkAtNb7uMGnNJwfIprmb ttoIlxLzBtItNw83ZWDtL42jktturQckY61YzLG8mA6BQ+SDI8VTACBiuevP9gFg4Nzk wZIZRDRC1CXxYH91nrLeTxf8wjoWTblyHDorn5C67MAmO+MP5xD1/aZJlbQqqQX0nmo+ 4LJUF+iIKvW/FqZU+vosrkBR0a2xDR2tGNFTLSVc52sOWU/UYu6E3x3nXmLpvwC7aW9S GzEg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1729530110; x=1730134910; h=cc:to:subject:message-id:date:from:reply-to:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=bqlzZ4m4X9RjL4yuSJpIpxBzp3UyScneM7XabjUeZtc=; b=uKmuF5AdcNz9huOyVC6Tq++Z1EFp0fq2tIi/DRVNhKZBxZpEP+oSXUPAFaEalBZHxj 8mGvS6Oy4zjG8PMCy5b/xyDG/cQF84YhZXoew0Uj5wTmbOPWEgQCyOP4gaGd/H/Ceuxh F3qRd0nN4qtt05BCVDi1uBlxF6kA7HC3PqN1M/Fo7dHpmzTk0aWArfvbizfZKhssy+ua ea6llRTdNmOJQq0/yZz4eKK/1y3LFUsL/2K61vI/h9j0CpUeHELApvPTemrIzyUcQZW3 h6rIpDDkGNnJ3F5BuZm2AiQAnq6mZE9Hm4+UF3i+d6qDxpoDjF8szixZlwbJr5a3V/0L rL9w== X-Forwarded-Encrypted: i=1; AJvYcCXwAsfl5MrjbSOk0zUpTPzJOxe/PhlTIdIHXf5qsa4QGd6mLBF1IGPP4lLrJMhs1dZZKf6Vp3z/4uepDbVM@lists.postgresql.org X-Gm-Message-State: AOJu0YyxPS/K7ZAlsRAbh6aq6Q2C/H+fGBHFex5VoeltOW3hNf/4dfgj 6tswciNXT6NpCCfjxLoRU9a65kRX3N2VKO5iKmH3+zbtqNg9Ii/T/ugDj+IdtmzD4+epKsYdyUW KLrJFQlipBLsNcnEAT3vI3CU+UO0= X-Google-Smtp-Source: AGHT+IHcn9esFP4n/Q9JXepRKIph7RUlS1JRQG3l9PSRGAWRlKYXXaP7YQwGsRE8pRxi3TYgBEXBd8Aj49otvOBk5EM= X-Received: by 2002:a05:6512:ba4:b0:539:f468:a51c with SMTP id 2adb3069b0e04-53a1546f995mr5726363e87.52.1729530108341; Mon, 21 Oct 2024 10:01:48 -0700 (PDT) MIME-Version: 1.0 References: <1554256.1729521467@sss.pgh.pa.us> <1569732.1729527394@sss.pgh.pa.us> In-Reply-To: <1569732.1729527394@sss.pgh.pa.us> Reply-To: zarkonesmall@gmail.com From: Anatolii Smolianinov Date: Mon, 21 Oct 2024 19:01:36 +0200 Message-ID: Subject: Re: Timezone: resolve $TZDIR in runtime To: Tom Lane Cc: Adrian Klaver , pgsql-general@lists.postgresql.org Content-Type: multipart/alternative; boundary="000000000000bc75ff0624ff9b9c" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000bc75ff0624ff9b9c Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable 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=E2=80=AFPM 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 > TZDIR, nor does it appear to affect actually-standard utilities > like date(1). > > regards, tom lane > --000000000000bc75ff0624ff9b9c Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Right, it is not an official standard, but TZDIR appe= ars in tzselect, which comes from GNU libc.=C2=A0 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:= =C2=A0
> use tzselect to find TZ"







On Mon, Oct 21, 2024 at 6:16=E2= =80=AFPM Tom Lane <tgl@sss.pgh.pa.us> wrote:
Anatolii Smolianinov <zarkonesmall@gmail.com> 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).

=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 regards, tom lane
--000000000000bc75ff0624ff9b9c--