From owner-freebsd-ports-bugs@freebsd.org Tue Mar 7 16:10:30 2017 Return-Path: Delivered-To: freebsd-ports-bugs@mailman.ysv.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:1900:2254:206a::19:1]) by mailman.ysv.freebsd.org (Postfix) with ESMTP id 80520D01AEF for ; Tue, 7 Mar 2017 16:10:30 +0000 (UTC) (envelope-from bugzilla-noreply@freebsd.org) Received: from kenobi.freebsd.org (kenobi.freebsd.org [IPv6:2001:1900:2254:206a::16:76]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (Client did not present a certificate) by mx1.freebsd.org (Postfix) with ESMTPS id 6FCEF138E for ; Tue, 7 Mar 2017 16:10:30 +0000 (UTC) (envelope-from bugzilla-noreply@freebsd.org) Received: from bugs.freebsd.org ([127.0.1.118]) by kenobi.freebsd.org (8.15.2/8.15.2) with ESMTP id v27GATXa072384 for ; Tue, 7 Mar 2017 16:10:30 GMT (envelope-from bugzilla-noreply@freebsd.org) From: bugzilla-noreply@freebsd.org To: freebsd-ports-bugs@FreeBSD.org Subject: [Bug 217515] [exp-run] Update PostgreSQL default version to 9.5 Date: Tue, 07 Mar 2017 16:10:30 +0000 X-Bugzilla-Reason: CC X-Bugzilla-Type: changed X-Bugzilla-Watch-Reason: None X-Bugzilla-Product: Ports & Packages X-Bugzilla-Component: Ports Framework X-Bugzilla-Version: Latest X-Bugzilla-Keywords: X-Bugzilla-Severity: Affects Many People X-Bugzilla-Who: tz@freebsd.org X-Bugzilla-Status: New X-Bugzilla-Resolution: X-Bugzilla-Priority: --- X-Bugzilla-Assigned-To: portmgr@FreeBSD.org X-Bugzilla-Flags: exp-run? X-Bugzilla-Changed-Fields: Message-ID: In-Reply-To: References: Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable X-Bugzilla-URL: https://bugs.freebsd.org/bugzilla/ Auto-Submitted: auto-generated MIME-Version: 1.0 X-BeenThere: freebsd-ports-bugs@freebsd.org X-Mailman-Version: 2.1.23 Precedence: list List-Id: Ports bug reports List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 07 Mar 2017 16:10:30 -0000 https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=3D217515 --- Comment #9 from Torsten Zuehlsdorff --- It seems you all reading me wrong! I'm not in favor of breaking thinks. I'm annoyed but that regularly, therefore the mention of other breakage. Heck, i have an 11 TB PostgreSQL cluster. That is nothing you just dump and restore= ... My point is: there is currently no (automatic) update path for PostgreSQL. There could be probably one when we are going to PostgreSQL 9.6, but this w= ill break things also. Not going to 9.6 will break other things. So, yes: breaking (especially a database) is a big no-go. But nobody mentio= ned even a possibility currently supported! Nobody raised, that the configuration between PostgreSQL versions are often incompatible. Let alone multiple changes in behavior causing problems. Nobo= dy mentioned that it is a really bad idea to update things automatically too. The update of the default version is a loss in any way. It will break thing= s no matter what you do. (I still have hope somebody proves me wrong. Please!) We just can argue with worse situation is not as worse as the other one. Best way would be to allow installation of two different versions, which wo= uld enable pg_migrate usage. But this need PostgreSQL 9.6, which will break thi= ngs through the renamed username. --=20 You are receiving this mail because: You are on the CC list for the bug.=