From owner-freebsd-ports@freebsd.org Tue Aug 4 21:27:22 2015 Return-Path: Delivered-To: freebsd-ports@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 97FE29B3FF8 for ; Tue, 4 Aug 2015 21:27:22 +0000 (UTC) (envelope-from girgen@pingpong.net) Received: from mailman.ysv.freebsd.org (mailman.ysv.freebsd.org [IPv6:2001:1900:2254:206a::50:5]) by mx1.freebsd.org (Postfix) with ESMTP id 8040E129C for ; Tue, 4 Aug 2015 21:27:22 +0000 (UTC) (envelope-from girgen@pingpong.net) Received: by mailman.ysv.freebsd.org (Postfix) id 7F8159B3FF7; Tue, 4 Aug 2015 21:27:22 +0000 (UTC) Delivered-To: ports@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 7F1BA9B3FF6 for ; Tue, 4 Aug 2015 21:27:22 +0000 (UTC) (envelope-from girgen@pingpong.net) Received: from mail.pingpong.net (mail.pingpong.net [79.136.116.202]) by mx1.freebsd.org (Postfix) with ESMTP id 0C8D01291; Tue, 4 Aug 2015 21:27:22 +0000 (UTC) (envelope-from girgen@pingpong.net) Received: from [192.168.1.12] (athedsl-249434.home.otenet.gr [85.73.21.248]) (using TLSv1 with cipher ECDHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by mail.pingpong.net (Postfix) with ESMTPSA id EB1ACB210; Tue, 4 Aug 2015 23:27:18 +0200 (CEST) Content-Type: text/plain; charset=utf-8 Mime-Version: 1.0 (1.0) Subject: Re: Proposal to fix postgresql package maintainance nightmare From: Palle Girgensohn X-Mailer: iPhone Mail (12H143) In-Reply-To: Date: Wed, 5 Aug 2015 00:26:14 +0300 Cc: =?utf-8?Q?Michael_Gr=C3=BCnewald?= , Baptiste Daroussin , FreeBSD Ports , "pgsql@freebsd.org" Content-Transfer-Encoding: quoted-printable Message-Id: <4E33531E-0290-4E49-8A23-C7960603A262@pingpong.net> References: <20150721094627.GD21594@ivaldir.etoilebsd.net> <3C35EF0A-38EF-452A-AC9D-21805F4A45DB@gmail.com> To: Kimmo Paasiala X-BeenThere: freebsd-ports@freebsd.org X-Mailman-Version: 2.1.20 Precedence: list List-Id: Porting software to FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 04 Aug 2015 21:27:22 -0000 > 4 aug 2015 kl. 14:33 skrev Kimmo Paasiala : >=20 >> On Tue, Aug 4, 2015 at 1:07 PM, Michael Gr=C3=BCnewald wrote: >>=20 >>> On 21 Jul 2015, at 11:46, Baptiste Daroussin wrote: >>> - Impossible to have tools from both old and new version at the same tim= e (which >>> is necessary to upgrade db and prepare upgrades of db) =E2=80=A6 >>=20 >> Could not jails be used to solve these issues by running the two (=E2=80=A6= ) required versions >> in jailed environments? There is a little bit of setup, but if by any ch= ance you >> are using some variation of the immutable server pattern, it should stay v= ery low. >=20 > You can't ask an average FreeBSD user who just wants to upgrade > his/her PostgreSQL installation to set up jails that would be only > used for one task. The upgrade should be achievable with just 'pkg > upgrade' without any extra work. >=20 > -Kimmo True. Also, pg_upgrade cannot operate using different jails. But for some ppl, jails if definitely a solution. The problem we're trying t= o solve is not that, though, it is when not using jails. Supporting pg_upgra= de is one of my main concerns, and also the ability to run several postgresq= l versions simultaneously for whatever reason.=20 Palle