PostgreSQL Backups to S3: The 3-2-1 Rule, Least-Privilege IAM and Tested Restores
How to back up PostgreSQL to Amazon S3 (or any S3-compatible service) safely: streaming pg_dump, an IAM user that can only upload, lifecycle rules for retention, protection against deletion and a script that tests restores automatically.
