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 1s6a5n-000UQM-PJ for pgsql-general@arkaria.postgresql.org; Mon, 13 May 2024 18:08:09 +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 1s6a5n-003crz-Sv for pgsql-general@arkaria.postgresql.org; Mon, 13 May 2024 18:08:07 +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 1s6a5n-003crk-Hw for pgsql-general@lists.postgresql.org; Mon, 13 May 2024 18:08:07 +0000 Received: from wfout8-smtp.messagingengine.com ([64.147.123.151]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1s6a5k-00034L-9X for pgsql-general@lists.postgresql.org; Mon, 13 May 2024 18:08:06 +0000 Received: from compute1.internal (compute1.nyi.internal [10.202.2.41]) by mailfout.west.internal (Postfix) with ESMTP id C45FC1C00124; Mon, 13 May 2024 14:08:02 -0400 (EDT) Received: from mailfrontend1 ([10.202.2.162]) by compute1.internal (MEProxy); Mon, 13 May 2024 14:08:02 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=aklaver.com; h= cc:cc:content-transfer-encoding:content-type:content-type:date :date:from:from:in-reply-to:in-reply-to:message-id:mime-version :references:reply-to:subject:subject:to:to; s=fm2; t=1715623682; x=1715710082; bh=qGqcZya4Jh/2gn91cP8LG1pyUzYqlecxFbB6g80MdnY=; b= rbndgW7Kqvae8GWkY7JYI/oSV6zxg1lIA0FXrVNhlHz/jtNPLjQyS3J2ZPU7bHi7 HgGcIayuwmrGK2daYHU/kK6bXrYRo9a5dCHaljHpaQgMcQ+Zg2cwRbqaVQ9aPF36 ToigUgrP980MroJznRQp4u8khuQGSdeBijbTHGNQ4P5Zm5pjQoNYlh6azWgyLf78 IX5rz2RDTl7k3ZEOPFJ/d4jBjB01xk2JZ3SRFfqY9hRA9S2MAFS6mHHGukvAQZPP aTDU9Wih3ndpvEubXe2jTu+UrdusXCryyzIEt6nUTfQwdJIlWpdO35ocTMRcmMUp IWEyL56yRK+b6PxrvYLdvw== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-transfer-encoding :content-type:content-type:date:date:feedback-id:feedback-id :from:from:in-reply-to:in-reply-to:message-id:mime-version :references:reply-to:subject:subject:to:to:x-me-proxy:x-me-proxy :x-me-sender:x-me-sender:x-sasl-enc; s=fm3; t=1715623682; x= 1715710082; bh=qGqcZya4Jh/2gn91cP8LG1pyUzYqlecxFbB6g80MdnY=; b=i ngoVWa/x1rSg88mLFRcARrTmx8uiaUHaXioEqQcUzTgS+ACFQKYQykzdCD4Pe0aK kSR0ELMwenhTU3GTIsv+NfqLHcYPUQHS4dA1TovkIwU2j0cr8Fu0JyW+me1pz7Vg FCcBqb6HlCzZFABAeFYbt2ojtWucrJaHvuuqR1WJeUeS0gdsMIzU5PRkERyuU9/K LqAe+3HKwq7rVRgkDBenLFDioCmML9mGVJbK7yJCoq7fh/Z4Ud1cvl6DBXHYOZEO RVFoKg0elJw32H4i0VqSCEsKDuMDeOx4cI+OUr4OU7BhM0doH0sqPvMaA/hOq7J2 xJyG6dy3gsXdYnB7HMqsg== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvledrvdeggedguddvtdcutefuodetggdotefrod ftvfcurfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfgh necuuegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmd enucfjughrpefkffggfgfuvfevfhfhjggtgfesthejredttddvjeenucfhrhhomheptegu rhhirghnucfmlhgrvhgvrhcuoegrughrihgrnhdrkhhlrghvvghrsegrkhhlrghvvghrrd gtohhmqeenucggtffrrghtthgvrhhnpefhveeihfevlefffedthedukeevfefhfedtgeei feevteffgfefhedtffetudettdenucevlhhushhtvghrufhiiigvpedtnecurfgrrhgrmh epmhgrihhlfhhrohhmpegrughrihgrnhdrkhhlrghvvghrsegrkhhlrghvvghrrdgtohhm X-ME-Proxy: Feedback-ID: i76984098:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Mon, 13 May 2024 14:08:01 -0400 (EDT) Message-ID: <7af7401e-eb82-442e-9010-6101d0ade808@aklaver.com> Date: Mon, 13 May 2024 11:07:59 -0700 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: UTC is not a time zone? To: Christophe Pettus Cc: "pgsql-generallists.postgresql.org" References: <327870A4-F35C-462C-9F64-E0838374AFDF@thebuild.com> <63e65356-9cb5-48b7-9bc5-5c734013ebe1@aklaver.com> <26FEAACB-9A3E-4823-98A9-FB5298822DD8@thebuild.com> Content-Language: en-US From: Adrian Klaver In-Reply-To: <26FEAACB-9A3E-4823-98A9-FB5298822DD8@thebuild.com> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 5/13/24 11:02 AM, Christophe Pettus wrote: > > >> On May 13, 2024, at 10:58, Adrian Klaver wrote: >> >> You sure the timezone file did not get changed under the connection? > > Yes (at least, nothing happened on the system that would indicate that). The system wasn't touched during the execution (and, as noted, it worked after as well as before). Hmm. What does pg_config --configure show for '--with-system-tzdata' ? > >> Why is SET TIMEZONE TO 'UTC being constantly called? > > ORM noise. -- Adrian Klaver adrian.klaver@aklaver.com