PGPASSWORD=mypassword pg_dump -Fc --no-acl --no-owner -h localhost -U myuser mydb > mydb.dump
I just find Dropbox so easy to use, so…
The default url for the file in Dropbox is
However, it would not work out of the box, because it’s one HTML, and Heroku is expecting one dump file.
The trick we could play is to change above url to:
heroku pgbackups:restore DATABASE 'https://dl.dropboxusercontent.com/XXXX/<filename>' --confirm <appname>