Date: Tue, 2 Jul 2019 09:03:26 +0200 From: Torsten Zuehlsdorff <freebsd@toco-domains.de> To: Alexey Dokuchaev <danfe@freebsd.org>, Matthias Fechner <idefix@fechner.net> Cc: Palle Girgensohn <girgen@freebsd.org>, ports-committers@freebsd.org, svn-ports-all@freebsd.org, svn-ports-head@freebsd.org Subject: Re: svn commit: r505245 - in head/databases: postgresql10-client postgresql10-contrib postgresql10-pgtcl postgresql10-server postgresql11-client postgresql11-server postgresql94-server postgresql95-cli... Message-ID: <e8446205-fccf-4e11-229a-7701aa348995@toco-domains.de> In-Reply-To: <20190630091359.GB59213@FreeBSD.org> References: <201906272128.x5RLS0Uv072609@repo.freebsd.org> <e0f21a7b-c748-b55a-d228-bae0f11fdfd2@fechner.net> <899f2367-828a-9eca-dfaa-e34a039fcdac@toco-domains.de> <20190629155606.GB97932@FreeBSD.org> <6ff9ed1f-1597-bc72-6ed2-e0bb634af8f7@fechner.net> <20190630091359.GB59213@FreeBSD.org>
next in thread | previous in thread | raw e-mail | index | archive | help
On 30.06.19 11:13, Alexey Dokuchaev wrote: > On Sat, Jun 29, 2019 at 07:14:11PM +0200, Matthias Fechner wrote: >> Am 29.06.2019 um 17:56 schrieb Alexey Dokuchaev: >>> We're using Postres in our production at $work and had to carefully evaluate >>> all 9.x versions, so it looks strange the GitLab works with 9.6 but not with >>> 9.5, as changes between these should be pretty minor AFAIR (in comparison to >>> e.g. 9.3). May we know what exactly breaks, so maybe we can craft a patch >>> to fix it? >> >> I do not fully remember what it was, but they use a feature that was >> added with 9.6 (used to retrieve data from the database with a more >> complex query): >> https://gitlab.com/gitlab-org/gitlab-ce/blob/master/doc/install/requirements.md#postgresql-requirements >> >> If you would like to have more details, there is an issue existing that >> describe why 9.6 is required in detail, but I do not have the link anymore. >> Maybe it is easier to check what new feature was added with 9.6. > > I tried to see what had changed but could only find version bump from 9.2 > to 9.6 in commits like these: > > https://gitlab.com/gitlab-org/gitlab-ce/commit/b609c8f650ca9854d12edbf623f2419c216e73a7 > https://gitlab.com/gitlab-org/gitlab-ce/commit/e1294022875138b40db7d34a9f33ac9f4a7dc655 > > I'd try to lower those number to 9.5, I'd expect with high probability > things would work just as fine. It depends on the features you use. PostgreSQL 9.6 was declared as mandatory for GitLab 12.0 because of the Geo Feature. If you don't use this feature, things will still work fine. Also as far as i recall there are some performance improvements only available for Users of 9.6+. >> So we should not block here to go to a more recent version. > > Yeah, which is, like, 10.x. :-) I will aim for 11. PostgreSQL 12 will be released around September 2019. This will make 9.5 unsupported and 9.6 the oldest supported release with its EOL next year. >From our point of view there is no big difference in the work needed. There is a break in FreeBSD PostgreSQL usage beginning with 9.6. This is because of the switch of the standard PostgreSQL user and data-dirs per version. So there is no difference in picking 9.6, 10 or 11. I set the change on my todo list. If somebody else want to do it, just notice me. Otherwise i will go ahead. Greetings, Torsten
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?e8446205-fccf-4e11-229a-7701aa348995>