From owner-svn-ports-head@freebsd.org Fri Apr 10 12:57:44 2020 Return-Path: Delivered-To: svn-ports-head@mailman.nyi.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2610:1c1:1:606c::19:1]) by mailman.nyi.freebsd.org (Postfix) with ESMTP id E7A612BD6F6; Fri, 10 Apr 2020 12:57:44 +0000 (UTC) (envelope-from kevans@freebsd.org) Received: from smtp.freebsd.org (smtp.freebsd.org [96.47.72.83]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) server-signature RSA-PSS (4096 bits) client-signature RSA-PSS (4096 bits) client-digest SHA256) (Client CN "smtp.freebsd.org", Issuer "Let's Encrypt Authority X3" (verified OK)) by mx1.freebsd.org (Postfix) with ESMTPS id 48zJ2c5sqPz424b; Fri, 10 Apr 2020 12:57:44 +0000 (UTC) (envelope-from kevans@freebsd.org) Received: from mail-qk1-f169.google.com (mail-qk1-f169.google.com [209.85.222.169]) (using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits)) (Client CN "smtp.gmail.com", Issuer "GTS CA 1O1" (verified OK)) (Authenticated sender: kevans) by smtp.freebsd.org (Postfix) with ESMTPSA id B8E82249A; Fri, 10 Apr 2020 12:57:44 +0000 (UTC) (envelope-from kevans@freebsd.org) Received: by mail-qk1-f169.google.com with SMTP id 13so1947414qko.10; Fri, 10 Apr 2020 05:57:44 -0700 (PDT) X-Gm-Message-State: AGi0PuZ7uZzoO8qrh9ROEp9RZtHRWstVvo0fY0EDkTnWtRHSLfUGE2M0 TtaXsmZclGbmi05m3AN3l3nNAO/f479lfxJiS6w= X-Google-Smtp-Source: APiQypK4nRRDnHJgm41YKJHMFV1aIdKivC3U3Ah4knmhDNer4q2dSR3HlDIptHRdjH4Df8XJpDOBPxcHAM7aIQGgAMc= X-Received: by 2002:a37:6d8:: with SMTP id 207mr3993414qkg.103.1586523464277; Fri, 10 Apr 2020 05:57:44 -0700 (PDT) MIME-Version: 1.0 References: <201911141624.xAEGOjTf052640@repo.freebsd.org> In-Reply-To: <201911141624.xAEGOjTf052640@repo.freebsd.org> From: Kyle Evans Date: Fri, 10 Apr 2020 07:57:31 -0500 X-Gmail-Original-Message-ID: Message-ID: Subject: Re: svn commit: r517600 - in head/databases: postgresql10-server postgresql11-server postgresql12-server postgresql94-server postgresql95-server postgresql96-server To: Palle Girgensohn Cc: ports-committers , svn-ports-all@freebsd.org, svn-ports-head@freebsd.org Content-Type: text/plain; charset="UTF-8" X-BeenThere: svn-ports-head@freebsd.org X-Mailman-Version: 2.1.29 Precedence: list List-Id: SVN commit messages for the ports tree for head List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 10 Apr 2020 12:57:45 -0000 On Thu, Nov 14, 2019 at 10:24 AM Palle Girgensohn wrote: > > Author: girgen > Date: Thu Nov 14 16:24:45 2019 > New Revision: 517600 > URL: https://svnweb.freebsd.org/changeset/ports/517600 > > Log: > Upgrade PostgreSQL > > The PostgreSQL Global Development Group has released an update to all > supported versions of our database system, including 12.1, 11.6, 10.11, > 9.6.16, 9.5.20, and 9.4.25. This release fixes over 50 bugs reported > over the last three months. > > PostgreSQL 9.4 will stop receiving fixes on February 13, 2020, which is > the next planned cumulative update release. We suggest that you make > plans to upgrade to a newer, supported version of PostgreSQL. Please see > our versioning policy for more information: > > This update also fixes over 50 bugs that were reported in the last > several months. Some of these issues affect only version 12, but may > also affect all supported versions. > > Specific change to the FreeBSD port: > Starting now, the default for TZDATA has changed to using the underlying OS' > time zone database instead of the one built in to PostgreSQL. This change is > made since PostgreSQL will not release a patch in the event where the time zone > database changes, whereas FreeBSD will. > Just a heads up- I guess it's maybe too late now, but this last change really should have had an associated UPDATING or something to that effect to go with it. The PostgreSQL-distributed set of zones doesn't match what FreeBSD distributes exactly and actively broke at least one users' config on upgrade[0]. This has since been worked around in base in a way that isn't all that spectacular and won't even hit releases where it's usable for people for at least another year, but we didn't seem to even warn folks outside of this small note in the commit message that they should be on the lookout. =-( Thanks, Kyle Evans [0] https://www.postgresql.org/message-id/12717.1573846407%40sss.pgh.pa.us