Upgrading to Postgres 13

[Sherry Lake]

When MUST we upgrade to Postgres 13?

We had trouble upgrading Postgres when we upgraded to DV V5.4, so we went back to Postgres V9.6.

I am now planning upgrades for UVa's Dataverse repo (from 5.5 to 5.9). Are any of the intermediate releases (5.6, 5.7, 5.8, 5.9) dependent on Postgres 13?

Thanks,

Sherry Lake

University of Virginia

[Philip Durbin]

Hi Sherry,

We use a tool called Flyway to handle database migrations in Dataverse and Flyway supports a specific range of PostgreSQL versions that we need to stay within (or switch to another tool, I guess).

In order to get Dataverse to work with PostgreSQL 14, we need to upgrade Flyway to a version that no longer supports PostgreSQL 9.6. This is probably for the best since 9.6 is pretty old at this point. We haven't upgraded Flyway yet ( https://github.com/IQSS/dataverse/pull/8296 hasn't been merged yet) so nothing has happened yet. However, in anticipation of upgrading Flyway some day, we're planning on including some messaging in the Dataverse 5.10 release notes that installations should upgrade from 9.6. You can actually review what this messaging will look like here if you'd like: https://github.com/IQSS/dataverse/pull/8310 (feedback is welcome, of course).

We expect Dataverse 5.11 to include the updated version of Flyway, therefore requiring PostgreSQL 10 or higher, with 13 being the version that we currently test with and recommend. 14 is out but isn't available everywhere (AWS RDS, for example). On my dev laptop, I just switched from 9.6 to 13.

I hope this helps,

Phil

--
You received this message because you are subscribed to the Google Groups "Dataverse Users Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to dataverse-commu...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/dataverse-community/8f772266-65a8-4510-874f-2d94d1935b0bn%40googlegroups.com.

--

Philip Durbin
Software Developer for http://dataverse.org
http://www.iq.harvard.edu/people/philip-durbin