I go with a simple pg_dumpall approach running on a cron job. It has worked well for over a decade on all sorts of different systems. Here's a complete walkthr

I go with a simple pg_dumpall approach running on a cron job. It has worked well for over a decade on all sorts of different systems. Here's a complete walkthrough on how I backup and restore: https://nickjanetakis.com/blog/how-to-back-up-postgresql-in-docker-local-s3-and-plakar https://nickjanetakis.com/blog/how-to-back-up-postgresql-in-... It covers using Plakar too (optionally) if you want deduplication and encryption.