Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1eHJ0K-0003q7-R4 for pgsql-hackers@arkaria.postgresql.org; Wed, 22 Nov 2017 00:35:04 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1eHJ0K-0002Br-Ey for pgsql-hackers@arkaria.postgresql.org; Wed, 22 Nov 2017 00:35:04 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1eHJ0K-0002Ba-9i for pgsql-hackers@lists.postgresql.org; Wed, 22 Nov 2017 00:35:04 +0000 Received: from sss.pgh.pa.us ([66.207.139.130]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1eHJ0F-0003t4-Va for pgsql-hackers@lists.postgresql.org; Wed, 22 Nov 2017 00:35:03 +0000 Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.4/8.14.4) with ESMTP id vAM0YvdI009005; Tue, 21 Nov 2017 19:34:57 -0500 From: Tom Lane To: Michael Paquier cc: Daniel Gustafsson , pgsql-hackers@lists.postgresql.org Subject: Re: Anybody care about having the verbose form of the tzdata files? In-reply-to: References: <1915.1511210334@sss.pgh.pa.us> <26240890-28E5-4FB6-8B84-16BA49A3F54A@yesql.se> Comments: In-reply-to Michael Paquier message dated "Wed, 22 Nov 2017 09:21:03 +0900" MIME-Version: 1.0 Content-Type: text/plain; charset="UTF-8" Content-ID: <9003.1511310897.1@sss.pgh.pa.us> Content-Transfer-Encoding: quoted-printable Date: Tue, 21 Nov 2017 19:34:57 -0500 Message-ID: <9004.1511310897@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Michael Paquier writes: > On Tue, Nov 21, 2017 at 6:28 PM, Daniel Gustafsson wro= te: > On 20 Nov 2017, at 21:38, Tom Lane wrote: >>> Anybody here actually care about reading the zone data files? >> I doubt there is anyone who cares about that who isn=E2=80=99t already = consuming the >> upstream data. > Perhaps I do. If this set of files gets removed and replaced by the zi > file, is it possible to still know easily which files are being > removed during a minor upgrade? When doing minor upgrades of a MSI > installer (Windows, yeah!), I need to keep track of files that get > deleted or a minor upgrade would simply fail. The tweak that I have is > to list them and recreate them as empty. The thing is ugly as hell, > but I need to be able to track which files are being removed easily. > And as far as I am checking, for example taking the rather recent > example of Riyadh87 in commit e04641f4, src/timezone/data allows to > keep easily track of files removed. If this gets removed, I am pretty > convinced that this tracking gets more complicated. I'm a bit confused. The files under src/timezone/data/ don't correspond to individual installed zone data files; most of them describe a lot of zones. (Riyadh87 and friends were outliers.) Seems to me that if you care about the installed file list, much the easiest way is to run "make install" and then look to see what's under share/timezones/. That wouldn't change if we use the abbreviated form of the zic input data. Now, personally, I've long diff'd the old and new timezone/data/ files in the process of writing the commit message for a tzdata update. I'd have to change that process --- but it was always a pretty tedious and obsessive-compulsive way to do it anyway, because most of the diffs are comments. I'd probably just start relying more fully on the IANA announcement emails, like this one: http://mm.icann.org/pipermail/tz-announce/2017-October/000047.html As far as I've seen, they are reliably good about summarizing everything you need to know about an update. They definitely always mention additions and removals of zones. regards, tom lane