#!/bin/bash
backup_dir="/mnt/will/large_data/Research_large_data/ClinicalTrialsDataProcessing/containers/AACT_Reloader/backup/"
date_stamp=$(date +%Y%m%d_%H%M%S)
filename="aact_db_backup_${date_stamp}.sql"

podman exec aact_db pg_dump -U root aact_db > "${backup_dir}/${filename}"

# Optional: compress the backup
gzip "${backup_dir}/${filename}"