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

[Galen Charlton]

Hi,

Thanks, folks. I've opened https://bugs.launchpad.net/evergreen/+bug/1830749
for bumping up the minimum to 9.6.

Regards,

Galen

On Tue, May 28, 2019 at 9:58 AM Bill Erickson <berickxx at gmail.com> wrote:

> +1 for PG 9.6 for EG 3.4.
>
> -b
>
> On Tue, May 28, 2019 at 9:06 AM Daniel Wells <dbwells at gmail.com> wrote:
>
>> Here's a third vote for upping to 9.6.  We've been on 9.6 on Ubuntu 16.04
>> since December.  No complaints.
>>
>> Dan
>>
>> On Tue, May 28, 2019 at 8:33 AM Boyer, Jason A <JBoyer at library.in.gov>
>> wrote:
>>
>>> 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
>>> >
>>>
>>>

-- 
Galen Charlton
Implementation and Services Manager
Equinox Open Library Initiative
phone:  1-877-OPEN-ILS (673-6457)
email:  gmc at equinoxInitiative.org
web:  https://equinoxInitiative.org
direct: +1 770-709-5581
cell:   +1 404-984-4366
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://libmail.georgialibraries.org/pipermail/open-ils-dev/attachments/20190528/216a0e79/attachment.html>