[OPEN-ILS-DEV] Time to increase the minimum required version of PostgreSQL?

[Boyer, Jason A]

I would also shy away from making 10 the minimum for 3.4 because I worry that we haven't shaken out the last compatibility issues, but I think we should definitely aim for 10 or 11 for 3.5. I've been running 9.6 in production since November so I would say it's a pretty safe choice to carry us through 3.4. After our local upgrade to 3.3 I'm planning to hammer on U18.04 and Pg10 more thoroughly.

Jason

--
Jason Boyer
MIS Supervisor
Indiana State Library
http://library.in.gov/

> -----Original Message-----
> From: Open-ils-dev [mailto:open-ils-dev-bounces at list.georgialibraries.org] On
> Behalf Of Jason Stephenson
> Sent: Thursday, May 23, 2019 3:41 PM
> To: open-ils-dev at list.georgialibraries.org
> Subject: Re: [OPEN-ILS-DEV] Time to increase the minimum required version of
> PostgreSQL?
> 
> **** This is an EXTERNAL email. Exercise caution. DO NOT open attachments or
> click links from unknown senders or unexpected email. ****
> ________________________________
> 
> Galen, et al.,
> 
> I think it is too soon to require Pg 10. While we advertise Evergreen as
> working with Pg 10, we don't actually install it on Ubnuntu 18.04 via
> the prerequisites.  We install Pg 9.6 instead.
> 
> We've found a few places already where set returning functions have
> caused us hangups in Pg 10.  I suspect that there are more of these
> hanging about in the database and in the storage and possibly other
> code.  I've been meaning to do a lot more testing with Pg 10 lately, but
> I've been busy with other things as well.
> 
> I think we should add a more comprehensive test suite to exercise all of
> the database code, including that in the Perl.  I know this overly
> ambitious, and I don't have a lot of time to spare to work on it,
> myself, so it's easy to say, isn't it?
> 
> Anyway, I don't have a problem with making Pg 9.6 the minimum required
> version for Evergreen 3.4, even thought that means that I will have to
> upgrade Pg as well.
> 
> Just my thoughts,
> Jason
>