How implement Postgres backups on Kubernetes?

Question

What's the best approach for backing up a Postgres on Kubernetes?

My first guess would have been to create a master-slave architecture with enabling replication. Doing an initial pg_basebackup and then fetching the WAL-logs. Once in a month I'd have scheduled another pg_basebackup with a cron, however containerized environemnts don't like cron daemons (no systemd available). How do you schedule base backups?

As mentioned in above comments, you coul use cronjob, there and there is an example of that, another idea might be to use operator, there is blog about that. — Jakub
– Jakub, Commented Jul 29, 2020 at 11:34

Eduardo Baitello · Accepted Answer · 2020-07-30 01:51:21Z

11

The best approach is to use the Kubernetes Cronjob resource:

You can use a CronJob to run Jobs on a time-based schedule. These automated jobs run like Cron tasks on a Linux or UNIX system.

Cron jobs are useful for creating periodic and recurring tasks, like running backups or sending emails.

You basically need to create a custom Linux image to run in your container jobs. This image will need a Postgres Client (so you can connect to your database with psql, pg_dump or pg_basebackup); and the credentials that can be configured as a secret.

You may want to upload the backup to external storage, so you can install and use awscli for AWS S3, gsutil for Google Cloud Storage, etc...

Here is some references:

edited Jul 30, 2020 at 1:51

answered Jul 29, 2020 at 12:48

Eduardo Baitello

11.6k7 gold badges53 silver badges82 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How implement Postgres backups on Kubernetes?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related