From owner-freebsd-ports@freebsd.org Tue Aug 4 11:47:26 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 D03279B3742 for ; Tue, 4 Aug 2015 11:47:26 +0000 (UTC) (envelope-from matthew@FreeBSD.org) Received: from smtp.infracaninophile.co.uk (smtp.infracaninophile.co.uk [IPv6:2001:8b0:151:1:3cd3:cd67:fafa:3d78]) (using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits)) (Client CN "smtp.infracaninophile.co.uk", Issuer "infracaninophile.co.uk" (not verified)) by mx1.freebsd.org (Postfix) with ESMTPS id 6DF71C7B for ; Tue, 4 Aug 2015 11:47:26 +0000 (UTC) (envelope-from matthew@FreeBSD.org) Received: from liminal.local (liminal.infracaninophile.co.uk [IPv6:2001:8b0:151:1:3636:3bff:fed4:b0d6]) (authenticated bits=0) by smtp.infracaninophile.co.uk (8.15.2/8.15.2) with ESMTPSA id t74BlHCr018714 (version=TLSv1.2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128 verify=NO) for ; Tue, 4 Aug 2015 12:47:18 +0100 (BST) (envelope-from matthew@FreeBSD.org) Authentication-Results: smtp.infracaninophile.co.uk; dmarc=none header.from=FreeBSD.org DKIM-Filter: OpenDKIM Filter v2.9.2 smtp.infracaninophile.co.uk t74BlHCr018714 Authentication-Results: smtp.infracaninophile.co.uk/t74BlHCr018714; dkim=none reason="no signature"; dkim-adsp=none; dkim-atps=neutral X-Authentication-Warning: lucid-nonsense.infracaninophile.co.uk: Host liminal.infracaninophile.co.uk [IPv6:2001:8b0:151:1:3636:3bff:fed4:b0d6] claimed to be liminal.local Subject: Re: Proposal to fix postgresql package maintainance nightmare To: freebsd-ports@freebsd.org References: <20150721094627.GD21594@ivaldir.etoilebsd.net> <3C35EF0A-38EF-452A-AC9D-21805F4A45DB@gmail.com> From: Matthew Seaman X-Enigmail-Draft-Status: N1110 Message-ID: <55C0A638.8050509@FreeBSD.org> Date: Tue, 4 Aug 2015 12:47:04 +0100 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.10; rv:38.0) Gecko/20100101 Thunderbird/38.1.0 MIME-Version: 1.0 In-Reply-To: Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="fu7G1elc6UkE6tOB96xtFie5q11koIUwd" X-Virus-Scanned: clamav-milter 0.98.7 at lucid-nonsense.infracaninophile.co.uk X-Virus-Status: Clean X-Spam-Status: No, score=-2.9 required=5.0 tests=ALL_TRUSTED,AWL,BAYES_00 autolearn=ham autolearn_force=no version=3.4.1 X-Spam-Checker-Version: SpamAssassin 3.4.1 (2015-04-28) on lucid-nonsense.infracaninophile.co.uk 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 11:47:27 -0000 This is an OpenPGP/MIME signed message (RFC 4880 and 3156) --fu7G1elc6UkE6tOB96xtFie5q11koIUwd Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable On 04/08/2015 12:33, Kimmo Paasiala wrote: > On Tue, Aug 4, 2015 at 1:07 PM, Michael Gr=C3=BCnewald 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) =E2=80=A6 >> >> 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= chance you >> are using some variation of the immutable server pattern, it should st= ay very 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. 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. Cheers, Matthew --fu7G1elc6UkE6tOB96xtFie5q11koIUwd Content-Type: application/pgp-signature; name="signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG/MacGPG2 v2.0.20 (Darwin) iQJ8BAEBCgBmBQJVwKZBXxSAAAAAAC4AKGlzc3Vlci1mcHJAbm90YXRpb25zLm9w ZW5wZ3AuZmlmdGhob3JzZW1hbi5uZXQ2NTNBNjhCOTEzQTRFNkNGM0UxRTEzMjZC QjIzQUY1MThFMUE0MDEzAAoJELsjr1GOGkATAGoP+wZ/G++WDp2BJoT2QK+aoC+r 1fUrCN3PLtwu5w0c7e9/FU1IwDJouSJj8FGXQ1rVnKi7YWsXj2hted3fyNTo1Q7I qTj8CIx0gbPAYI8DDGmppQhgtNbM/D6JIPuSuxyZlO59rR6kDndXyo6YaV4i+PVa p2QYSyEOF0kTl7aztmLOxJ2h6giwfHBCezJlGtPfqwAHv1sLYFtMJ2XF6/TuP2gb 8przPFsBhj1FW9AiDX6bypPPL7cTXpqvH2kpreU2Is83YTLvjP9LMGRt4RgmdMN/ oE46WAfNuvEsn+Lk1ZCoVtnCGb7yb6kGrDYRzkULRh05WiiH2LOVRqvYI2ERfsi/ 06ysg8aGIzrty4leGiFp3xfilP4GpLu/KIw+Ef4ccpTlAy5k6YJon1kzS2Ri4Fop iACODUNIbZ9tnhmspRT9X0KOMwbsZtjnCUzRN8Qf3xeVxapCqDvurvx6EFi8zrc2 dVeonmQlzcLKrlHzbOLa3KAG51IXg96yv6JCu4/SE/uGSaIAucVxxbqWSYctI5e8 wfRYD9hYZORfNlPgJhmOc/22a52qzOfFm20NQzDeqBbtYYbotF4Pp79/58t+8MN9 8WTHJwshbk8aCEuW/eeC4jA+qBvWQJpiVya9x79/Y133M8I30DWp0XMbzI4fdftt k5DA2vDKp+j44PzPJ9+/ =awWA -----END PGP SIGNATURE----- --fu7G1elc6UkE6tOB96xtFie5q11koIUwd--