Add Support for PostgreSQL 15

Bug #1997098 reported by Jason Stephenson
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Evergreen
Fix Released
Medium
Unassigned

Bug Description

PostgreSQL 15 was released October 13. We should add installation support for this new version of PostgreSQL so that Evergreen users can keep up with the latest releases.

tags: added: install-upgrade
description: updated
tags: added: database
Revision history for this message
Jason Stephenson (jstephenson) wrote (last edit ):

Branch is here: https://git.evergreen-ils.org/?p=working/Evergreen.git;a=shortlog;h=refs/heads/collab/dyrcona/lp1997098-support-postgresql-15

PgTap and Perl tests pass on a fresh install of Concerto.

NB: There is a db upgrade script as two indexes needed to be modified for the drop of immutability on the function used to cast intervals to text.

Changed in evergreen:
status: In Progress → Confirmed
milestone: none → 3.next
tags: added: pullrequest
Changed in evergreen:
assignee: Jason Stephenson (jstephenson) → nobody
Changed in evergreen:
milestone: 3.next → 3.11-beta
Revision history for this message
Jason Stephenson (jstephenson) wrote :

I have rebased this branch on master as of commit 39c44d2c0a6f5eab4d93b564b079be1cf75d85f2 and force-pushed.

I changed the target to 3.11-beta because I would like to see 3.11 support Pg 15.

We still have the open question of what Pg version to recommend, but if this branch and the one from bug 1999274 go in, there's no known reason to not recommend any Pg version of 12 or higher.

Bill Erickson (berick)
Changed in evergreen:
assignee: nobody → Bill Erickson (berick)
Revision history for this message
Bill Erickson (berick) wrote :

Base install and db upgrade script worked as expected. Tests look good. Basic UI navigation works well too. Merged to EG master for 3.11. Thanks, Jason!

Changed in evergreen:
status: Confirmed → Fix Committed
assignee: Bill Erickson (berick) → nobody
tags: added: signedoff
Changed in evergreen:
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.