...
If you downloaded a physical backup which is now stored on your local machine, and want to restore from that specific file, you will first need to upload it to s3, creating create a signed URL for the dump, and then finally run:
heroku pg:backups:restore '<SIGNED_URL_IN_S3>' DATABASE_URL # note the (DATABASE_URL is a literal, not a placeholder.)
...