We're Hiring!

Are Omero database backups OS agnostic?

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.

Are Omero database backups OS agnostic?

Postby Aking » Tue Aug 21, 2012 9:19 am

Hi
Couldn't find out from the documentation if Omero database backups are OS agnostic? So for example could I start on a Windows box then migrate to Linux (with a change in config file I guess) at a later date?
Thanks
Andy
Aking
 
Posts: 19
Joined: Tue Aug 07, 2012 10:50 am

Re: Are Omero database backups OS agnostic?

Postby cxallan » Tue Aug 21, 2012 10:59 am

PostgreSQL database archives created with pg_dump are designed to be portable between architectures. The worst case I could think of is that you wouldn't be able to restore a custom dump (http://www.postgresql.org/docs/9.1/stat ... -dump.html).
cxallan
Site Admin
 
Posts: 509
Joined: Fri May 01, 2009 8:07 am

Re: Are Omero database backups OS agnostic?

Postby Aking » Fri Oct 12, 2012 12:18 pm

In case its of use to anyone else I can confirm this works as expected going from Windows 7 Enterprise to Ubuntu 12 LTS as host OS. I found I just needed to ensure the new empty database name and owning user for import into postgresql matched the source database of the dump file.
Aking
 
Posts: 19
Joined: Tue Aug 07, 2012 10:50 am


Return to Installation and Deployment

Who is online

Users browsing this forum: No registered users and 1 guest