Crontab for Postgres backup executed via docker

Opening the crontab editor:

crontab -e

Suggested command line:

00 05 * * * cd /home/icc-ps-iccsg01/docker && /usr/bin/docker compose exec -T postgresql pg_dumpall -U postroot | gzip > ../backups/databases/postgres-$(date +\%Y-\%m-\%d-\%H-\%M-\%S).sql.gz

Details:

00 05 * * * - cron schedule, in this case daily, at 5 AM

cd /home/USER/docker - accesses the folder where the docker container is running

/usr/bin/docker compose exec -T CONTAINERNAME pg_dumpall -U ROOTUSER

gzip > ../backups/databases/postgres-$(date +\%Y-\%m-\%d-\%H-\%M-\%S).sql.gz - stores the dump in sql.gz