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.