PerkinElmer Informatics Support Forum
Decrease font size
Increase font size
Topic Title: How do I Backup and Restore the omero database
Topic Summary: commands to backup and restore the omero db
Created On: 3/17/2017 9:57 AM
Status Post and Reply
Linear : Threading : Single : Branch
Topic Tools Topic Tools
View topic in raw text format. Print this topic.
 3/17/2017 9:57 AM
User is offline View Users Profile Print this message


RAH

Posts: 68
Joined: 5/16/2014

There is a cronjob which runs to backup the omero db and this cron job is normally set to run on a nightly basis at ~2am.

Columbus stores the resultant backup file (pg_dump file) in /OMERO/OMERO4_4/db_backup

The dump files are updated nightly with a maximum of 3 pg_dump files being retained.

It is possible to backup the omero db manually by using the pg_dump utility. The arguments specified in the command dictate how the dump is created. More information regarding pg_dump can be found on the following webpage:

https://www.postgresql.org/docs/9.4/static/app-pgdump.html

Manually create a db dump (log in as the 'columbus' user):

$ pg_dump -Fc -v -f /OMERO/OMERO4_4/db_backup/omero4_4_backup.pg_dump omero4_4

Restore the db dump:

$ sudo /etc/init.d/columbus stop

$ pg_restore -v -c -Fc -d omero4_4 /OMERO/OMERO4_4/db_backup/omero4_4_backup.pg_dump

$ sudo /etc/init.d/columbus start

----------------------------------

RAH



Edited: 4/3/2017 at 8:52 AM by RAH

FuseTalk Basic Edition v4.0 - © 1999-2018 FuseTalk Inc. All rights reserved.