[Bug 217515] [exp-run] Update PostgreSQL default version to 9.5

[bugzilla-noreply at freebsd.org]

https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=217515

--- Comment #14 from Torsten Zuehlsdorff <tz at freebsd.org> ---
(In reply to Mathieu Arnold from comment #6)

> I have not used dump/restore since pre 8.4 days, pg_upgrade works just fine, but 
> you have to have the old and new servers installed at the same time.

> Of course it does not work with the way we currently do things, but this is 
> mostly because people are quite happy with breaking everyone's setups each time 
> the default changes. 

Just one important point: it is *not* a good idea to do pg_upgrade
automatically. I believe with the changes done in PostgreSQL 9.6 by girgen it
should be possible to use pg_upgrade much easier.
But as stated previous: automatic update is a bad idea. Behavior changes,
functions are removed and so on.

And since you bring the point up: we really need to do something against the
breakings. Even as a port committer i'm not able to cope with the last breaks
anymore. I just have two options left: pkg lock and hope best for the rest or
do not upgrade at all. That is very very bad...

@Chris:
I wont stop you - but i did not understand your solution proposal either ;) Can
you please make it more clear? Or do you want to just create a prototype for
testing and show it to us?

-- 
You are receiving this mail because:
You are on the CC list for the bug.