We're Hiring!

Fresh install with old data

Having a problem deploying OMERO? Please ask new questions at https://forum.image.sc/tags/omero
Please note:
Historical discussions about OMERO. Please look for and ask new questions at https://forum.image.sc/tags/omero

The OMERO.server installation documentation begins here and you can find OMERO.web deployment documentation here.

Fresh install with old data

Postby PhilippeP » Tue May 15, 2018 2:14 pm

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
PhilippeP
 
Posts: 44
Joined: Tue Oct 22, 2013 1:31 pm

Re: Fresh install with old data

Postby jmoore » Tue May 15, 2018 2:22 pm

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.:


Cheers,
~Josh
User avatar
jmoore
Site Admin
 
Posts: 1591
Joined: Fri May 22, 2009 1:29 pm
Location: Germany

Re: Fresh install with old data

Postby PhilippeP » Tue May 15, 2018 2:58 pm

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
PhilippeP
 
Posts: 44
Joined: Tue Oct 22, 2013 1:31 pm

Re: Fresh install with old data

Postby jmoore » Tue May 15, 2018 3:13 pm

Hi Philippe,

the version is stored in the PostgreSQL database.

~Josh.
User avatar
jmoore
Site Admin
 
Posts: 1591
Joined: Fri May 22, 2009 1:29 pm
Location: Germany

Re: Fresh install with old data

Postby PhilippeP » Wed May 16, 2018 9:05 am

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... :oops:
Do you know what it is?
PhilippeP
 
Posts: 44
Joined: Tue Oct 22, 2013 1:31 pm

Re: Fresh install with old data

Postby kennethgillen » Wed May 16, 2018 9:21 am

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
 
Posts: 254
Joined: Mon Nov 05, 2012 3:39 pm

Re: Fresh install with old data

Postby PhilippeP » Thu May 17, 2018 12:41 pm

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
PhilippeP
 
Posts: 44
Joined: Tue Oct 22, 2013 1:31 pm


Return to Installation and Deployment

Who is online

Users browsing this forum: No registered users and 1 guest