Add Support for PostgreSQL 16

[Jason Stephenson]

Now that Pg 16 is released, we should add installation support for PostgreSQL 16.

https://www.postgresql.org/about/news/postgresql-16-released-2715/

[Jason Stephenson (jstephenson)]

I have pushed a branch that I have been testing for the past week: working/user/dyrcona/lp2037656-add-p16.

https://git.evergreen-ils.org/?p=working/Evergreen.git;a=shortlog;h=refs/heads/user/dyrcona/lp2037656-add-p16

I've been using Pg16 with an upgraded copy of production data and RedisRF and have been hitting the vm wit test programs fetching data over osrf-gateway-v1 as well as running database updates, etc. I have encountered no issues so far, and all database and Perl tests pass.

I think this is ready for more eyes, particularly on the performance of Did-you-mean, which I have disabled on this test system.

[Jane Sandberg (sandbergja)]

Thanks, Jason! I've been using postgres 16 and your patch for development for a while now, and have noticed no ill effects. I am signing off on that basis: user/sandbergja/lp2037656-add-p16-signoff / https://git.evergreen-ils.org/?p=working/Evergreen.git;a=shortlog;h=refs/heads/user/sandbergja/lp2037656-add-p16-signoff

I can't speak to how postgres 16 works in production-like environments, particularly with regard to then did-you-mean feature.

[Jason Stephenson (jstephenson)]

Thanks for the signoff, Jane!

I have pushed a rebased branch based on main that includes the install docs update for disabling the JIT.

The rebase omits Jane's signoff because it won't hurt to test this again.

working/user/dyrcona/lp2037656-add-p16-rebase (https://git.evergreen-ils.org/?p=working/Evergreen.git;a=shortlog;h=refs/heads/user/dyrcona/lp2037656-add-p16-rebase)

[Jason Stephenson (jstephenson)]

Rebased and added Jane's signoff: collab/dyrcona/lp2037656-add-pg16-signoff (https://git.evergreen-ils.org/?p=working/Evergreen.git;a=shortlog;h=refs/heads/collab/dyrcona/lp2037656-add-pg16-signoff)

I'm prepping code for inclusion in 3.14.

[Jason Stephenson (jstephenson)]

The Evergreen branch above conflicts with the branch for bug 2054842. Whichever goes in to main first, the other will require a rebase.

[Josh Stompro (u-launchpad-stompro-org)]

Tested PG16 with Ubuntu 24.04 and install went well, along with all tests passing.

Signoff Branch with adjustments for Ubuntu 24.04 at
working: user/stompro/lp2037656-add-pg16-signoff-plus-24.04

https://git.evergreen-ils.org/?p=working/Evergreen.git;a=shortlog;h=refs/heads/user/stompro/lp2037656-add-pg16-signoff-plus-24.04

[Jason Stephenson (jstephenson)]

Thanks, Jane and Josh for the testing and the rebase!

I have pushed this to main for inclusion in Evergreen 3.14.