I just finished a setup where I run PostgreSQL as a quadlet on CoreOS, and in order to manage backups I use systemd Require so the postgres container depends on a pgbackrest container that just runs a relatively simple script to check if storage is empty or not, and restores the backup from S3 if storage is empty.
And another container runs as a oneshot timer that takes full and incremental backups to S3.
Instead of this [1] I use a much simpler while ! pg_isready loop.
1. https://gist.github.com/efrecon/86456960e2110b287632fd7f42c1...