Page 1 of 1

Are Omero database backups OS agnostic?

PostPosted: Tue Aug 21, 2012 9:19 am
by Aking
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

Re: Are Omero database backups OS agnostic?

PostPosted: Tue Aug 21, 2012 10:59 am
by cxallan
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).

Re: Are Omero database backups OS agnostic?

PostPosted: Fri Oct 12, 2012 12:18 pm
by Aking
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.