Stream: dev

Topic: Updating to Postgres 15?

Sherry Lake (Mar 11 2025 at 14:33):

From my sysamin.....

Is there a migration of dataverse to Postgres 15 on the roadmap for this year? Postgres 13 goes end-of-life this year and we need a plan to move off it soonish...

Philip Durbin 🚀 (Mar 11 2025 at 14:34):

The 6.6 release notes will say something about how for testing we have moved from Postgres 13 to 16.

Philip Durbin 🚀 (Mar 11 2025 at 14:35):

Harvard Dataverse is still on Postgres 13.

Philip Durbin 🚀 (Mar 11 2025 at 14:35):

So, yes, we need to get off Postgres 13 before it goes EOL.

Sherry Lake (Mar 11 2025 at 14:35):

Thanks, UVA just upgraded to V6.5.

Will wait until the Summer or Fall for further updates.

Philip Durbin 🚀 (Mar 11 2025 at 14:36):

Do you have your eye on Postgres 15 specifically?

Sherry Lake (May 13 2025 at 16:41):

My sysadmin is asking about this again:
will this be in V6.7?

Or are we to upgrade ourselves... and will not be part of release notes in a step to do (like solr and Payara upgrades)?

Philip Durbin 🚀 (May 13 2025 at 18:48):

We don't have any changes planned for 6.7 with regard to Postgres.

Oliver Bertuch (May 22 2025 at 16:21):

Kind of related: I described in #troubleshooting > Upgrading 5.14 to 6.2 @ 💬 how to use Flyway migrations outside of a deployment. Currently adding a new Maven module to run these migrations in an automated fashion with a single Maven call. Can also be used to test all of our migrations going forward and on new versions of Postgres.

Oliver Bertuch (May 22 2025 at 16:38):

@Philip Durbin I should add some docs about it's usage. Add to admin guide or installation guide? Dev guide even?

Philip Durbin 🚀 (May 22 2025 at 16:39):

Would it fit in https://guides.dataverse.org/en/6.6/developers/sql-upgrade-scripts.html ?

Oliver Bertuch (May 22 2025 at 16:46):

Sure. But might be too hidden for admins.

Oliver Bertuch (May 22 2025 at 16:46):

On the other hand, this is experimental... So maybe that's alright being located in the dev guide.

Oliver Bertuch (May 22 2025 at 16:46):

I created an issue: https://github.com/IQSS/dataverse/issues/11516

Philip Durbin 🚀 (May 22 2025 at 16:47):

Looks great. We're using Flyway in https://github.com/IQSS/dataverse-hub and https://github.com/IQSS/dataverse-marketplace too, by the way.

Philip Durbin 🚀 (May 22 2025 at 16:48):

@Juan Pablo Tosca Villanueva @Gustavo Durand ^^

Oliver Bertuch (May 22 2025 at 16:54):

Aaaaand a PR: https://github.com/IQSS/dataverse/pull/11517 (still needs the doc bits)

Philip Durbin 🚀 (May 22 2025 at 16:58):

I was gonna say, docs please! :smile:

Oliver Bertuch (May 22 2025 at 17:32):

Hey it's a draft

Oliver Bertuch (May 22 2025 at 17:32):

I just need to get the pieces in place for my talk :sweat_smile:

Philip Durbin 🚀 (May 22 2025 at 17:33):

CDD! Conference Driven Development! :smile:

Last updated: Nov 01 2025 at 14:11 UTC