Postgres Backups for Applications (shusson.info)

Maybe worth checking out pgbackrest (https://pgbackrest.org/) as an open source external tool for Postgres backup / restore if you have not already.