Inquiry regarding DB version upgrade on irods

[kovid bhardwaj]

Hi ,

We are currently in the process of upgrading our database- postgresql 9.2.24 to the latest version 14.2 due to the fact that the current version is no longer supported and has reached its End of Life (EoL). As part of this upgrade, we would like to inquire about any potential impact on our application and whether any configuration changes would be required.

Could you kindly provide insight into the following:

1. Application Impact: Are there any known impacts on our application if we upgrade the database to the latest version? Specifically, are there any compatibility issues or potential disruptions that we should be aware of?

2. Configuration Changes: Do we need to make any specific configuration changes within our application to ensure compatibility with the latest version of the database? If so, could you provide details on the changes that would be necessary?

Waiting to hear from you . 

Thanks

Kovid

[Kory Draughn]

Hi Kovid,

The biggest challenge for upgrading the database is normally making sure your OS has the proper drivers and is compatible with the installed version of unixODBC.

iRODS 4.2 has always been tested against PostgreSQL 10 and I'm sure others have run it against later versions. iRODS 4.3 is tested against PostgreSQL 14. You shouldn't have any issues with those versions.

PostgreSQL 15 made some changes which need some investigation. I recommend sticking with v14 for now. See https://github.com/irods/irods/issues/7382.

Other than that, make sure to have a backup of your database, follow normal database upgrade guidelines, and verify the changes in a test environment before moving into production.

Hope that helps.

Kory Draughn

Chief Technologist

iRODS Consortium

--
--
The Integrated Rule-Oriented Data System (iRODS) - https://irods.org
 
iROD-Chat: http://groups.google.com/group/iROD-Chat
---
You received this message because you are subscribed to the Google Groups "iRODS-Chat" group.
To unsubscribe from this group and stop receiving emails from it, send an email to irod-chat+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/irod-chat/dfd139c0-57b9-4679-9f01-74e7d6ffac85n%40googlegroups.com.

[kovid bhardwaj]

Hi Kory,

We are currently using iRODS version 4.2.8. Does this version support PostgreSQL v14? If not, what is the most recent version of PostgreSQL that is compatible with iRODS 4.2.8?

[Terrell Russell]

The limitation we saw with older iRODS - was not iRODS itself, but rather, the unixODBC version on the operating system that is running the iRODS catalog provider.

https://github.com/irods/irods/issues/5325

I expect PostgreSQL 14 works fine with 4.2.8, with an updated unixODBC - but this is not 'supported' as it was not tested at that time (in fact, PG14 was released more than a year later).

Terrell

To view this discussion on the web visit https://groups.google.com/d/msgid/irod-chat/5e83391d-1188-4011-8e77-11a05fe346c3n%40googlegroups.com.

[kovid bhardwaj]

Hi Russell,

This is our current configuration:

unixODBC-2.3.1-14

irods 4.2.8 (prod) ; irods 4.2.11 (Dev)

postgresql-9.6

1. is postgresql v12 supported or tested with irods v4.2.8 or 4.2.11 ?

2. Since postgresql-9.6 has crossed the end of life and v12 is recommended by our DB team, do we need to update DB drivers or unixODBC version if we move to v12 . Does this require any configuration changes in irods ?

Thanks

Kovid

[Terrell Russell]

We only tested with versions that were shipped on the supported OSs at the time of shipping.

If unixODBC is configured correctly, then iRODS will be happy without iRODS configuration changes.

Terrell

To view this discussion on the web visit https://groups.google.com/d/msgid/irod-chat/3c81082b-f73b-4d56-8857-c3716819b0ecn%40googlegroups.com.

[kovid bhardwaj]

Hi Russell,

Our irods OS version is RHEL 7.9 
do we need to modify any configuration file of unixODBC,  if we upgrade to v12 of postgres . ?

[Alan King]

I don't think we have had to make many (if any) changes for our unixODBC configurations for testing the iRODS server over many versions of Postgres, but that depends on what configurations you need in your deployment.

You should try an upgrade in a testing environment with a configuration similar to what you are using in production and see if anything falls over.

To view this discussion on the web visit https://groups.google.com/d/msgid/irod-chat/7937089b-c925-48e2-a12b-3ca44bf53617n%40googlegroups.com.

--

Alan King

Senior Software Developer | iRODS Consortium