pg_restore: [archiver] did not find magic string in file header: please check the source URL and ensure it is publicly accessible
So I have tried to use Dropbox and other services, but I had the same error until the tenth attempt. Here is what I did:


I logged in to my with my Heroku cli from my terminal on the master branch so I don't have to redefine the app. (specify the path to your damp. I have mine on the same directory) e.g:

[murph@ComputerX languageandcode]$
the I run 

[murph@ComputerX languageandcode]$ heroku pg:psql &lt; langandcode.sql

Then I became happy as pushing started and completed successfully.