Skip to content

Instantly share code, notes, and snippets.

@francoism90

francoism90/README.md

Last active June 6, 2025 15:25
Show Gist options
  • Save francoism90/9c010105ce9cdab25958e27a5e9f57cc to your computer and use it in GitHub Desktop.
Save francoism90/9c010105ce9cdab25958e27a5e9f57cc to your computer and use it in GitHub Desktop.
Download ZIP
Simple pg_dump setup
Raw
README.md

Simple PostgreSQL backup

Introduction

This is a simple database dump script for a Podman PostgreSQL container.

systemd/Timers

Create a service, replace myapp with your container-name (e.g. hub-pgsql):

$ systemctl --user edit container-dump --full --force
[Unit]
Description=Run pg_dump on PostgreSQL container
Requires=myapp-pgsql.service
After=myapp-pgsql.service

[Service]
Type=oneshot
ExecStart=~/.local/bin/backup-container.sh

[Install]
WantedBy=multi-user.target

Test the service:

$ systemctl --user start container-dump

To create the systemd timer:

$ systemctl --user edit container-dump.timer --full --force
[Unit]
Description=Run pg_dump on PostgreSQL container daily

[Timer]
OnCalendar=*-*-* 4:00:00
Persistent=true

[Install]
WantedBy=timers.target

To enable the systemd timer:

$ systemctl --user enable container-dump.timer --now
Raw
backup-container.sh
#!/bin/bash
USERNAME=myuser
PASSWORD=mypass
DATABASE=mydb
EXPORT_PATH=/var/home/archie/dumps
EXPORT_FILENAME="${DATABASE}-$(date +%Y%m%d%H%M%S).zstd"
podman exec -it systemd-myapp-pgsql /bin/bash -c "PGPASSWORD=$PASSWORD pg_dump -h localhost -U $USERNAME -Z zstd:3 $DATABASE" > "${EXPORT_PATH}/${EXPORT_FILENAME}"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment