Date: Tue, 07 Mar 2017 15:18:18 +0000 From: bugzilla-noreply@freebsd.org To: freebsd-ports-bugs@FreeBSD.org Subject: [Bug 217515] [exp-run] Update PostgreSQL default version to 9.5 Message-ID: <bug-217515-13-Z7t31gzKty@https.bugs.freebsd.org/bugzilla/> In-Reply-To: <bug-217515-13@https.bugs.freebsd.org/bugzilla/> References: <bug-217515-13@https.bugs.freebsd.org/bugzilla/>
next in thread | previous in thread | raw e-mail | index | archive | help
https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=3D217515 Chris Hutchinson <portmaster@bsdforge.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |portmaster@bsdforge.com --- Comment #7 from Chris Hutchinson <portmaster@bsdforge.com> --- (In reply to Mathieu Arnold from comment #6) > I have not used dump/restore since pre 8.4 days, pg_upgrade works just fi= ne, > but you have to have the old and new servers installed at the same time. >=20 > 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. And because nobody on pgsql@ wants to take a d= ay > to figure out how to do it correctly. OK. What follows is off the top of my pointy little head. But... I think it's going to be POLA no matter which/any direction is chosen. But the first couple of things that come to mind are chroot(8), of even creating a port that facilitates the entire process. Those with any sizable DB (should) understand the maintenance costs, already. But seems to me the simplest solution; in the short term, anyway; is chrooting the proposed new version, and finally moving it into it's final destination. While I's early. I haven't finished my first cup of coffee, and haven't completely thought this through; am I completely off the map? --Chris --=20 You are receiving this mail because: You are on the CC list for the bug.=
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?bug-217515-13-Z7t31gzKty>