[nickjj]

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-...

It covers using Plakar too (optionally) if you want deduplication and encryption.