Omero database recovery from OMERO directory

[hroque]

Hi all,

Recently I lost access to my RAID setup. This meant new install from scratch. Now the physical database (eg the OMERO directory where pixels are stored) I could recover but not the tree database (eg users, trees, logins, etc).
Is there any way to recover at least databases and projects from reading the OMERO directory so I can at least give put back the data?

Thanks,

[jmoore]

Unfortunately there's not. Unless you have a backup of your postgresql database all the metadata from the system is lost. You may be able to inspect the raw files under /OMERO/Files or the log files to determine some of what was lost, but it will certainly be time intensive. If there are any particulars we can help you with, please let us know.

~Josh.

[hroque]

After long I finally got the database back online.
Just a quick question: is a pg_dump sufficient to recover the whole postgresql database in case of full crash again? This assuming that the OMERO folder is untouched?

Thanks,
Helio

[jmoore]

Correct. You need /OMERO and the pg_dump for the omero database (named "omero" in the install docs) in order to recover from a catastrophic failure.

Cheers,
~Josh.