[Evergreen-dev] Evergreen 3.14 - Remove support for PostgreSQL 10 (and 11 and 12) ?

[Mike Rylander]

Hi all,

I'm not against bumping the PG version requirement for EG 3.14, but I
don't feel too strongly either way.

However, I have pushed a branch to
https://git.evergreen-ils.org/?p=working/Evergreen.git;a=shortlog;h=refs/heads/user/miker/old-polymorphic-syntax
which uses the slightly stricter (and older) anyelement syntax for
polymorphic functions.  I have a pastebin published at
https://pastebin.com/DkxdE6Yu that will let you confirm the change
works in the case we need, where the first and third parameters to the
evergreen.redact_value() function come from a table column of
arbitrary type (a bigint in the test) and a quoted string literal
generated by the reporter.

I apologize for the churn! I thought anycompatible was much older than it is.

Thanks,

--
Mike Rylander
Research and Development Manager
Equinox Open Library Initiative
1-877-OPEN-ILS (673-6457)
work: miker at equinoxOLI.org
personal: mrylander at gmail.com
https://equinoxOLI.org

On Fri, Sep 20, 2024 at 12:03 PM Jason Stephenson via Evergreen-dev
<evergreen-dev at list.evergreen-ils.org> wrote:
>
> Hi, all.
>
> I think we should set the minimum version of PostgreSQL required for
> Evergreen 3.14 to PostgreSQL 13. This is me speaking as a member of the
> 3.14 release team, and as the person who usually works on adding
> installation support for new PostgreSQL releases in Evergreen.
>
> According to the PostgreSQL versioning policy, Pg 10 & 11 are out of
> community support, and Pg 12 community support ends on November 14, 2024.
>
> See https://www.postgresql.org/support/versioning/
>
>
> I think that continuing to support obsolete database versions is holding
> us back, and many of the optimization tricks we've added for those older
> releases would no longer be needed. In my testing on the same hardware
> an unoptimized PostgreSQL 16 database is generally faster than an
> optimized PostgreSQL 10 database. This is with production data, but not
> a production work load.
>
> Just my, $2.00 (inflation),
> Jason Stephenson
> _______________________________________________
> Evergreen-dev mailing list
> Evergreen-dev at list.evergreen-ils.org
> http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-dev