Proposal to fix postgresql package maintainance nightmare

[Matthew Seaman]

On 04/08/2015 12:33, Kimmo Paasiala wrote:
> On Tue, Aug 4, 2015 at 1:07 PM, Michael Grünewald <michipili at gmail.com> wrote:
>>
>>> On 21 Jul 2015, at 11:46, Baptiste Daroussin <bapt at 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) …
>>
>> 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.

	Cheers,

	Matthew


-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 971 bytes
Desc: OpenPGP digital signature
URL: <http://lists.freebsd.org/pipermail/freebsd-ports/attachments/20150804/ba9249e7/attachment.bin>