Open Microscopy Environment

Hi there, I am a biologist, not a computer person. So please bear my likely down-to-earth question...

We had a major computer problem, and have to reinstall everything on it (it runs Ubuntu 16.04).
Our University computer wizards agreed to give us a hand to reinstall OMERO with our data, since I have a backup of our +/-14TB OMERO data (including: data, DropBox, FullText, ManagedRepository Thumbnails BioFormatsCache Files lost+found and Pixels) from the last version we were using (5.2, I think...).

My question:
Is it possible for them to reinstall the current OMERO version and then link it to our data backup, or do they have to reinstall the OMERO version that produced the data to be able to link it to the OMERO data backup?
I hope I am clear, here...
Any help on that topic would be greeeeeatly appreciated!

Thanks,
Philippe

Hi Phillipe,

What version of OMERO were you running previously?

In general, I'd assume the only thing you would need to do is restore the PostgreSQL database and apply the several database upgrade scripts which are needed between your version and the current version, e.g.:

• http://docs.openmicroscopy.org/omero/5.4.6/sysadmins/server-upgrade.html
• http://docs.openmicroscopy.org/omero/5.3.5/sysadmins/server-upgrade.html
• etc.

Cheers,
~Josh

Hi Josh,

jmoore wrote:What version of OMERO were you running previously?

I am pretty sure it was 5.2.x.x, but I don't know the "x.x"...
Is there a way to precisely find out from some of the data present in our backup (data, DropBox, FullText, ManagedRepository Thumbnails BioFormatsCache Files lost+found and Pixels)?

Thanks anyway for your answer.
Philippe

Hi Philippe,

the version is stored in the PostgreSQL database.

~Josh.

jmoore wrote:the version is stored in the PostgreSQL database.

Hi Josh,
Following your above advice to identify the OMERO version that we used, my colleagues are now asking me: "Do you known what the SQL query is to get the OMERO version?"

Well, I don't...
Do you know what it is?

Hi,

The following should get you the latest entry in the "dbpatch" table which should give you the latest version and "patch" level.

Code: Select all

SELECT currentversion, currentpatch FROM dbpatch ORDER BY ID DESC LIMIT(1);

Cheers,

Kenny

kennethgillen wrote:The following should get you the latest entry in the "dbpatch" table which should give you the latest version and "patch" level.

Yes it did.
Thanks Kenny.
Philippe