Recommended PostgreSQL version for Pulpcore 3.31.0

Support
#1

Problem:

Hi,
I’m seeking guidance on a PostgreSQL upgrade for our production environment. We’re currently running Pulpcore 3.31.0 with PostgreSQL 12.9 and need to upgrade to a higher version.

Our current stack:

  • Pulpcore: 3.31.0
  • Django: 4.2.0 (LTS)
  • psycopg: 3.1.10
  • Current PostgreSQL: 12.9
  • Environment: AWS Aurora PostgreSQL

Since PostgreSQL 13 reaches EOL in November 2025, we can’t upgrade to that version.
I wasn’t able to find clear documentation on PostgreSQL version compatibility for our specific Pulpcore version.
Could you please advise: What’s the latest PostgreSQL version we can safely upgrade to?

Use case: RHEL package mirroring with reposync + Pulp distribution.

Pulpcore version:
pulpcore==3.31.0

Pulp plugins installed and their versions:
pulp-certguard==1.6.5
pulp-certguard-client==1.6.5
pulp-cli==0.21.2
pulp-container==2.16.0
pulp-file==1.14.4
pulp-glue==0.21.2
pulp-rpm==3.22.3

Operating system - distribution and version:
RHEL 8.10

Thanks!

#2

We recently switched all our testing to postgresql 16. And we may start to use specific features thereof with anything >= pulpcore 3.85.
In the past, PostgreSQL has been particularly unproblematic to be used in newer versions.

#3

Thanks for the clarification, that’s very helpful!

We’re currently running Pulpcore 3.31.0 with PostgreSQL 12.9 (Aurora). From your note, it seems upgrading directly to PostgreSQL 16 should work with our current Pulpcore version. Can you confirm?

Really appreciate your guidance!

#4

Sorry I am not going to “confirm” anything (at least not in a legal sense).
I can tell you what we test, and I can give you suggestions. I hope you can stage up a system with whatever you upgrade to in order to look for smoke first.
Now, I’m almost certain we had users running on psql 15 for a long time, but I cannot tell if that goes back as far as pulpcore 3.31.*. Also given that 3.31 will no longer receive any updates from our side, I would suggest to upgrade to one of 3.39, 3.49, 3.63, 3.73 or the most recent one (No these numbers do not follow a pattern, but out of our control business needs). These y-versions are currently tested in our pipelines using psql 16.

2 Likes
#5

Thanks for clarifying, that makes sense.

We’ll plan to stage a test environment first before upgrading production to ensure there are no surprises. Given that 3.31 is no longer maintained, we’ll also look into moving to a newer Pulpcore release (one of the y-versions you suggested) along with upgrading to PostgreSQL 16.

Appreciate the guidance and the pointers on tested versions!

2 Likes