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 1rfiD1-001kx5-95 for pgsql-bugs@arkaria.postgresql.org; Thu, 29 Feb 2024 15:20:31 +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 1rfiCz-0055RI-P2 for pgsql-bugs@arkaria.postgresql.org; Thu, 29 Feb 2024 15:20:30 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rfiCz-0055RA-GR for pgsql-bugs@lists.postgresql.org; Thu, 29 Feb 2024 15:20:29 +0000 Received: from sss.pgh.pa.us ([68.162.161.243]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rfiCw-0026eq-Od for pgsql-bugs@lists.postgresql.org; Thu, 29 Feb 2024 15:20:29 +0000 Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.pgh.pa.us (8.15.2/8.15.2) with ESMTP id 41TFKOkx2697847; Thu, 29 Feb 2024 10:20:24 -0500 From: Tom Lane To: jgrg@sanger.ac.uk cc: pgsql-bugs@lists.postgresql.org Subject: Re: BUG #18372: Timezone documentation and use of TZ and PGTZ environment variables missing since version 7.4 In-reply-to: <18372-af2560d77b3ba5b7@postgresql.org> References: <18372-af2560d77b3ba5b7@postgresql.org> Comments: In-reply-to PG Bug reporting form message dated "Thu, 29 Feb 2024 10:47:34 +0000" MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <2697845.1709220024.1@sss.pgh.pa.us> Content-Transfer-Encoding: quoted-printable Date: Thu, 29 Feb 2024 10:20:24 -0500 Message-ID: <2697846.1709220024@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk PG Bug reporting form writes: > As far as I can tell, the documentation of the TZ and PGTZ environment > variables read by the PostgreSQL still behaves as described in the > documentation for version 7.4: > https://www.postgresql.org/docs/7.4/datatype-datetime.html#DATATYPE-TIME= ZONES > but is absent from more recent versions. Hm? PGTZ is still mentioned there, assuming I'm looking at the same spot you are. As for TZ, it's now magic to initdb but not the server, so the documentation mention moved. See this 9.2-era commit: https://git.postgresql.org/gitweb/?p=3Dpostgresql.git&a=3Dcommitdiff&h=3Dc= a4af308c32d03db5fbacb54d6e583ceb904f268 regards, tom lane