Image Artist: Backing up the Postgres databases

Overview

Image Artist includes several PostgreSQL databases which store critical information, including:

• User account information 
• Job Status page content 
• Search API index 
• Data storage index (Image Artist 1.4+)

Automated Backup Process

Image Artist automatically captures a daily backup of all databases, with:

• Frequency: Daily
• Output Location: /SImA/db_backup/[timestamp] (timestamp format: %d-%m-%Y_%H%M%S)
• Retention Policy: 30 most recent backups are preserved; older backups are automatically deleted

Manual Backup Process

Its also possible to capture a database backup manually:

1. Navigate to the Image Artist installation directory
2. Execute the backup script: backup_postgres_dbs.sh
3. Backups will be stored in the same location as automated backups (/SImA/db_backup/[timestamp])

## Example Output

sima@simahost:$ ./backup_postgres_dbs.sh
*** Backing up databases from Docker service SImA_postgres.1.3fgp5k3o9pesdqwj69d8jogec to directory /SImA/db_backup/09-04-2024_091135.
*** Backing up DB keycloak.
*** Backing up DB batch_analysis.
*** Backing up DB sima_api.
*** Backing up DB sima_webapp.
*** DB's backed up.

*** Backing up Docker configs and secrets
*** Configs and secrets backed up.

Deleting oldest backups...
Current postgres backup count 31 greater than the limit 30, deleting oldest backups....