How to restore backup tar.gz file from console command?

I can confirm that from inside a production container you want to run discourse restore, not script/discourse.

Also, you can run it without the filename and it’ll suggest the available files, which makes it easy to copy and paste the filename.