I automated my nightly backups using the schickling/postgres-backup-s3 docker image. If you don't use docker this is overkill. However, if you do use docker, this is a pretty small process which backs up postgres and uploads it to s3. postgres-restore-s3 is nice for restoring backups should you need it. This is also nice for production => dev server (or local server).