Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hYCB7-00013f-I0 for pgsql-hackers@arkaria.postgresql.org; Tue, 04 Jun 2019 16:20:49 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hYCB6-0007iF-De for pgsql-hackers@arkaria.postgresql.org; Tue, 04 Jun 2019 16:20:48 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hYCB6-0007hm-0b for pgsql-hackers@lists.postgresql.org; Tue, 04 Jun 2019 16:20:48 +0000 Received: from lungold.riddles.org.uk ([82.68.208.19]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hYCB3-0004BO-NN for pgsql-hackers@postgresql.org; Tue, 04 Jun 2019 16:20:46 +0000 Received: from [192.168.127.1] (port=40207 helo=caithnard.riddles.org.uk) by lungold.riddles.org.uk with esmtps (TLSv1.2:ECDHE-RSA-AES256-GCM-SHA384:256) (Exim 4.88 (FreeBSD)) (envelope-from ) id 1hYCB0-0005Nq-Qr; Tue, 04 Jun 2019 16:20:42 +0000 Received: from [127.0.0.1] (port=32043 helo=caithnard.riddles.org.uk) by caithnard.riddles.org.uk with esmtp (Exim 4.89 (FreeBSD)) (envelope-from ) id 1hYCB0-000231-5u; Tue, 04 Jun 2019 16:20:42 +0000 From: Andrew Gierth To: Christoph Berg Cc: Tom Lane , PostgreSQL Hackers Subject: Re: UCT (Re: pgsql: Update time zone data files to tzdata release 2019a.) In-Reply-To: <20190604085735.GD24018@msg.df7cb.de> (Christoph Berg's message of "Tue, 4 Jun 2019 10:57:35 +0200") Message-ID: <87ftop8gtr.fsf@news-spur.riddles.org.uk> References: <20190604085735.GD24018@msg.df7cb.de> User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/25.1 (berkeley-unix) Date: Tue, 04 Jun 2019 17:20:42 +0100 MIME-Version: 1.0 Content-Type: text/plain List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk >>>>> "Christoph" == Christoph Berg writes: Christoph> There is something wrong here. On Debian Buster/unstable, Christoph> using system tzdata (2019a-1), if /etc/timezone is Christoph> "Etc/UTC": Christoph> 11.3's initdb adds timezone = 'UCT' to postgresql.conf Christoph> 12beta1's initdb add timezone = 'Etc/UCT' to postgresql.conf fwiw on FreeBSD with no /etc/localtime and no TZ in the environment (and hence running on UTC), I get "UCT" on both 11.3 and HEAD. -- Andrew (irc:RhodiumToad)