Date: Tue, 4 Aug 2015 12:47:04 +0100 From: Matthew Seaman <matthew@FreeBSD.org> To: freebsd-ports@freebsd.org Subject: Re: Proposal to fix postgresql package maintainance nightmare Message-ID: <55C0A638.8050509@FreeBSD.org> In-Reply-To: <CA%2B7WWSf%2BmYJL=Fe5cX6jnG93EgK4eaQJ4KLN1HE0-uOnsAZq5A@mail.gmail.com> References: <20150721094627.GD21594@ivaldir.etoilebsd.net> <3C35EF0A-38EF-452A-AC9D-21805F4A45DB@gmail.com> <CA%2B7WWSf%2BmYJL=Fe5cX6jnG93EgK4eaQJ4KLN1HE0-uOnsAZq5A@mail.gmail.com>
next in thread | previous in thread | raw e-mail | index | archive | help
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 <michipili@gmail= =2Ecom> wrote: >> >>> On 21 Jul 2015, at 11:46, Baptiste Daroussin <bapt@freebsd.org> 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--
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?55C0A638.8050509>