Currently, Pulp builds and tests against Postgres-13. This is a Really Old Version; we use it because we have a significant userbase that relies on it, and we try to avoid inadvertently adding features that would require a newer DB.
However - Postgres-13 is going EOL in November 2025. We’d like to no longer rely on it well before then, to give folk who need to, time to upgrade before they start missing security fixes
In pursuit of this goal, we’d like to settle on a more-recent Postgres for our CI and oci-images. I can see from https://analytics.pulpproject.org/ that we have users on everything up to and including Postgres-17(!), so it looks like we work on those versions.
One consideration here is the next “long term” support we’re likely to face (centos-10-stream’s beta is shipping Postgres-16, for example)
Does anyone have Opinions on “features it would be really cool to see Pulp take advantage of” in newer versions?