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

[Bill Erickson]

+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
>> >
>>
>>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://libmail.georgialibraries.org/pipermail/open-ils-dev/attachments/20190528/9db20eab/attachment-0001.html>