PerkinElmer Informatics Support Forum
Decrease font size
Increase font size
Topic Title: How do I backup the columbus_webapp db?
Topic Summary: command to backup the webapp
Created On: 12/10/2018 10:27 AM
Status Post and Reply
Linear : Threading : Single : Branch
Topic Tools Topic Tools
View topic in raw text format. Print this topic.
 12/10/2018 10:27 AM
User is offline View Users Profile Print this message


RAH

Posts: 75
Joined: 5/16/2014

Columbus creates and utilizes 2 databases, the omero4_4 db and also the columbus_webapp db.

Both are backed up by a script which runs under /etc/cron.daily and are, by default, stored in /OMERO/OMERO4_4/db_backup

To view details of how to backup the omero4_4 db, click here

To manually backup the columbus_webapp you must first switch to the 'columbus' user account and issue the following command:

$ su columbus -
$ pg_dump -v -Fc -f /OMERO/OMERO4_4/db_backup/columbus_webapp-TEST.pg_dump columbus_webapp

pg_dump -v -Fc -f - the arguments used as part of the pg_dump process to create the backup
/OMERO/OMERO4_4/db_backup/ - the location where you want the backup to be stored
columbus_webapp-TEST.pg_dump - the name of the backup file
columbus_webapp - the name of the db being backed up

RAH

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