I wish this article would have went more in-depth on how they're setting up backups. The great thing about sequel light is lightstream makes backup and restore something you don't really have to think about
for postgres specifically pgbackrest works well. Using in a home doing backups to r2 and local s3.
ZFS snapshot, send, receive, clone, spin up another postgresql server on the backup server, take full backup on that clone once per week