Théo Morin/
FR

Open source tool

pgpilot

A CLI that sets up automatic backups of a Kubernetes cluster's PostgreSQL databases to S3 storage.

WebsiteGitHub

pgpilot connects to PostgreSQL over the network, like any other client: there is nothing to add to the pods and nothing to change in the existing manifests. Point-in-time recovery (PITR) is supported too, through continuous WAL archiving.

What I built

  • One CronJob per database, running pg_dump and sending the result to S3 compatible storage.
  • No sidecar, no changes to the pods and no conflict with GitOps.
  • Credentials come from existing Kubernetes Secrets, never stored in plain text.