PatronX

PatronX is a small toolkit for managing PostgreSQL backups and point‑in‑time restores. It is written in typed Python and exposes a concise command‑line interface. Backups can be scheduled, diffed and off‑loaded to S3 with a minimal setup.

Docker Tags are available on Docker Hub:

Utilities

backup and enqueue-backup upload the dumps to s3 if s3 is configured.

Configuration

The following environment variables control how PatronX connects to the database and schedules jobs:

• PGHOST – database host (default localhost)
• PGPORT – database port (default 5432)
• PGUSER – authentication user (default test_user)
• PGPASSWORD – password for PGUSER
• PGDATABASE – database name (default test_db)
• BACKUP_DIR – where dumps are stored (default ./backups)
• BACKUP_CRON – cron expression for automated backups
• CLEANUP_CRON – cron expression for removing old dumps
• RETENTION_DAYS – how long to keep dumps (default 30)
• S3_BUCKET – optional bucket for S3 uploads
• AMQP_URL – RabbitMQ connection string
• LOGSTASH_HOST – Logstash host (default logstash)
• LOGSTASH_PORT – Logstash port (default 5000)
• HEALTH_PORT – port for the built‑in health server (default 7775)

Docs

For guidance on setting up an IAM user with minimum access for S3 uploads, see docs/aws-user-creation.md.

Development

Install uv:

pip install uv

pytest                   # run tests

ruff check . --fix       # lint

isort .                  # format imports

generate requirements.txt

uv pip install pip-tools

uv pip-compile --output-file=requirements.txt pyproject.toml