Backup restore failing due to .tar versus .tar.gz file extension

Why did you need to make changes to the backup file created by Discourse? Did you create manually create the tar file (on MacOS)? I’ve seen reports where it uses a different tar format which causes problems during decompression.

You might need to create a new tar file with the --format ustar option or, even better, create a new backup directly in a Discourse Docker container.