[Fixed]-Unable to correctly restore postgres data: I get the same error I usually get if I haven't run syncdb and migrate

Try those same steps WITHOUT running syncdb and migrate at all. So overall, your steps will be:

heroku pg:backups capture

curl -o latest.dump heroku pg:backups public-url

`scp -P latest.dump myuser@example.cloudapp.net:/home/myuser

drop database mydb;

create database mydb;

pg_restore --verbose --clean --no-acl --no-owner -U myuser -d mydb latest.dump