Upgrading to XNAT 1.10

[Paul Smith]

Hi,

We're planning to upgrade from XNAT 1.9 to 1.10 soon, but have a couple of questions.

I've seen that XNAT 1.10 is validated against PostgreSQL 16 to 18. We're currently running PostgreSQL 14 and so need to upgrade. Does anyone know if XNAT 1.9 is tested against PostgreSQL 18?

Here's what I'm currently planning to do for a test instance:

- upgrade PostgreSQL to version 16

- upgrade XNAT to 1.10 and Java to 21

- upgrade PostgreSQL to version 18

- test our custom plugins to see if any need updating

Is this reasonable, or could everything be done in a single step (i.e. upgrade PostgreSQL at the same time as upgrading XNAT and Java)?

Thanks,

Paul

[Rick Herrick]

Hi Paul,

Depending on how you're planning on upgrading PostgreSQL, you may not need to do the 14->16->18 upgrade path. If you're just dumping your database from 14 then importing it into 18 that should be fine. That's generally how we manage it, largely because the PostgreSQL cluster upgrade process for PostgreSQL is such a pain.

Also, XNAT 1.10.0 runs just fine on PostgreSQL 14! And XNAT 1.9 runs just fine on PostgreSQL 16 and 18. You should definitely upgrade PostgreSQL as well as XNAT, but the order in which you do the upgrades is not critical.

Since you're working on a test instance before upgrading your production system(s) (which is definitely the best practice for this sort of thing), you can try both upgrading one or the other first and upgrading them both at the same time. I would probably do this by upgrading the database first, restarting Tomcat and making sure everything is functioning properly, then upgrading Java and XNAT next, but that is out of an abundance of caution.

The most important things to consider are:

• Make sure you have a full backup of your database safely stored somewhere
• Keep users from accessing the system until you've completed the upgrades and validated that the system works properly (we run through a small battery of smoke tests that includes logging in, creating a subject in a validation project, uploading a session, etc.) 
• Run through the process on your test instance to eliminate any stumbling blocks then follow the same process when upgrading your production system

Let us know how you go about the actual upgrade and whether you run into any issues!

Rick Herrick 

Senior Software Developer

ri...@xnatworks.io

https://xnatworks.io | Find us on LinkedIn! 

--
You received this message because you are subscribed to the Google Groups "xnat_discussion" group.
To unsubscribe from this group and stop receiving emails from it, send an email to xnat_discussi...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/xnat_discussion/8337d150-39dc-442e-8963-82ba7b7a28a2n%40googlegroups.com.

[Paul Smith]

Hi Rick,

That's super helpful, thanks. I'll probably upgrade to PostgreSQL 18 first, then do XNAT and Java. I'll let you know how it goes!

Thanks,

Paul