✔ Postgres 16 · community · Zulip Chat Archive

Hello .. wondering if an upcoming release will include upgrading Postgres from v13 .. I thought the recommendation was still for 13 but I see in the installation docs 16 is recommended. I know community support ends in Nov. Should we just go ahead and upgrade? Sorry if this has been discussed. I searched. :slight_smile:

Philip Durbin 🚀 (Sep 11 2025 at 18:18):

6.8 docs will show the same as 6.7.1 docs which say this:

"PostgreSQL 16 is recommended because it’s the version we test against." -- https://guides.dataverse.org/en/6.7.1/installation/prerequisites.html#postgresql

In the 6.6 release notes we had this to say:

End-Of-Life (EOL) Announcements

PostgreSQL 13 reaches EOL on 13 November 2025

Per https://www.postgresql.org/support/versioning/ PostgreSQL 13 reaches EOL on 13 November 2025. Our first step toward moving off version 13 was to switch our testing to version 16, as we've noted in the guides. You are encouraged to start planning your upgrade and may want to review the Dataverse 5.4 release notes as the upgrade process (e.g. pg_dumpall, etc.) will likely be similar. If you notice any bumps along the way, please let us know!

Dataverse developers using Docker have been using PostgreSQL 17 since Dataverse 6.5 (#10912). (Developers not using Docker who are still on PostgreSQL 13 are encouraged to upgrade.) Older or newer versions should work, within reason.

Philip Durbin 🚀 (Sep 11 2025 at 18:20):

As mentioned above, https://github.com/IQSS/dataverse/releases/tag/v5.4 has an "upgrade postgres" step for upgrading from postgres 9 to 13 and I assume that upgrading from 13 to 16 or 17 would be similar.

Deirdre Kirmis (Sep 11 2025 at 18:33):

okay thanks!

Philip Durbin 🚀 (Sep 11 2025 at 18:37):

Sure, please keep in mind that I'm just a developer who drops the database on his laptop almost every day. :sweat_smile:

Don Sizemore (Sep 12 2025 at 12:11):

@Deirdre Kirmis at UNC we've upgraded all of our Postgres DBs to major version 16, (finally) completing the last one last week. No problems so far and as Phil says IQSS has been testing against this version for some time now.