...
In the unlikely event you have to restore from a logical backup, because you can’t use the continuous protection rollback, and all the dumps managed by Heroku are somehow unavailable, : download the logical backup you want to use from s3, and run:
heroku pg:psql --app scihist_digicoll_production < logical_backup.sql
...