#!/bin/sh
USERNAME=user
PASSWORD=password
DATABASE=database
EXPORT_PATH=/mnt/backup/dumps
EXPORT_FILENAME="${DATABASE}-$(date +%Y%m%d%H%M%S)"

# export as .sql
podman exec -it systemd-myapp-pgsql /bin/bash -c "PGPASSWORD=${PASSWORD} pg_dump -h localhost -U ${USERNAME} ${DATABASE}" > "${EXPORT_PATH}/${EXPORT_FILENAME}.sql"

# export as volume
podman volume export myapp-pgsql --output "${EXPORT_PATH}/${EXPORT_FILENAME}.tar"