From owner-freebsd-ports@freebsd.org Sat Aug 15 14:53:06 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 47FDB9BA797 for ; Sat, 15 Aug 2015 14:53:06 +0000 (UTC) (envelope-from michelle@sorbs.net) Received: from hades.sorbs.net (hades.sorbs.net [67.231.146.201]) by mx1.freebsd.org (Postfix) with ESMTP id 37C681CFA; Sat, 15 Aug 2015 14:53:05 +0000 (UTC) (envelope-from michelle@sorbs.net) MIME-version: 1.0 Content-transfer-encoding: 8BIT Content-type: text/plain; charset=UTF-8 Received: from isux.com (firewall.isux.com [213.165.190.213]) by hades.sorbs.net (Oracle Communications Messaging Server 7.0.5.29.0 64bit (built Jul 9 2013)) with ESMTPSA id <0NT4006AYPMDWV00@hades.sorbs.net>; Sat, 15 Aug 2015 07:59:03 -0700 (PDT) Message-id: <55CF5247.3090307@sorbs.net> Date: Sat, 15 Aug 2015 16:52:55 +0200 From: Michelle Sullivan User-Agent: Mozilla/5.0 (Macintosh; U; Intel Mac OS X; en-US; rv:1.8.1.24) Gecko/20100301 SeaMonkey/1.1.19 To: Matthew Seaman Cc: freebsd-ports@freebsd.org Subject: Re: Proposal to fix postgresql package maintainance nightmare References: <20150721094627.GD21594@ivaldir.etoilebsd.net> <3C35EF0A-38EF-452A-AC9D-21805F4A45DB@gmail.com> <55C0A638.8050509@FreeBSD.org> In-reply-to: <55C0A638.8050509@FreeBSD.org> 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: Sat, 15 Aug 2015 14:53:06 -0000 Matthew Seaman wrote: > On 04/08/2015 12:33, Kimmo Paasiala wrote: > >> On Tue, Aug 4, 2015 at 1:07 PM, Michael Grünewald wrote: >> >>>> On 21 Jul 2015, at 11:46, Baptiste Daroussin wrote: >>>> - Impossible to have tools from both old and new version at the same time (which >>>> is necessary to upgrade db and prepare upgrades of db) … >>>> >>> Could not jails be used to solve these issues by running the two (…) required versions >>> in jailed environments? There is a little bit of setup, but if by any chance you >>> are using some variation of the immutable server pattern, it should stay very low. >>> >>> >> 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. >> > > It's unlikely that 'pkg upgrade' would ever grow the facility to > automatically do a fast binary update of the data directory from one > postgresql release to another one. > > However, being able to install things in such a way that pg_upgrade(1) > could be used to do all that would be very much more useful than the > current 'dump databases ; upgrade packages ; reload databases' fandango. > I'm just doing this - 8.4 -> 9.4 and 9.0 -> 9.4 on some machines... Its not that difficult to get pg_upgrade working... Don't know under pkgng, but under pkg_* tools and my mangled ports tree to make it to continue to work with pkg_* tools I just did this: ( cd /usr/ports/databases/postgresql90-server && LOCALBASE=/usr/local.upgrade PKG_DBDIR=/var/db/pkg.upgrade make install ) ..to get the current version installed in it's own little environment, then shut the server down, deinstalled the existing 9.0 (using pkg_delete ) and installed 9.4 normally using '( cd /usr/ports/databases/postgresql94-server && make install )' and now I can use pkg_upgrade ... My failing point is ip4r 1.x -> 2.x but that's a completely separate issue in many ways... (and has it's own solutions). Regards, -- Michelle Sullivan http://www.mhix.org/