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