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:[email protected]] On > Behalf Of Jason Stephenson > Sent: Thursday, May 23, 2019 3:41 PM > To: [email protected] > 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 >
