Database backup
Local installations of Flow Production Tracking are no longer offered. This documentation is intended only for those with existing instances of Flow Production Tracking Enterprise Docker. Click here for a list of our current offerings.
This articles explains how to take a backup of a Flow Production Tracking database.
It is intended for Flow Production Tracking System Administrators.
The database backup utility is available inside the dbops Docker image shipped with Flow Production Tracking. It can be used to take a snapshot of the database. This is especially useful prior to upgrading the production instance.
Take a database backup by running:
docker-compose run --rm dbops pg_dump -v -Fd -j 2 --schema=public -f /db_backup/db-shotgun-$(date +%Y%m%d-%H%M%S) The output will be a directory (using pg_dump -Fd option) suitable for input into pg_restore. The backup directory will be in db_backup subfolder by default (relative to the Compose file). The output directory can be modified in the Compose file.
Increasing the number of threads (-j) will allow the backup to complete more quickly, but will add more load on the database.
More information about pg_dump can be found on the PostgreSQL support site:
https://www.postgresql.org/docs/12/app-pgdump.html.