Import Heroku Backup, Local Docker Postgres DB, Windows 10 Home

instructions.txt

# OS - Windows 10 Home (which requires Docker Toolbox since it doesn't support Hyper-V)
# Backup was generated from Heroku (which uses pg_dump)
# Backup location: C:\Users\Patrick\Desktop\tmp\latest.dump (change accordingly below)
# Docker image - https://hub.docker.com/_/postgres/

docker run --name some-postgres -v //c/Users/Patrick/Desktop/tmp:/hostfiles/ -e POSTGRES_PASSWORD=password -d postgres 

docker exec -it some-postgres pg_restore -U postgres -d postgres -1 /hostfiles/latest.dump

# Error. Copy the role name.
# like qwerasdfqwerasdf

docker run -it --rm --link some-postgres:postgres postgres psql -h postgres -U postgres
# Type "password"
CREATE ROLE qwerasdfqwerasdf;
\q

docker exec -it some-postgres pg_restore -U postgres -d postgres -1 /hostfiles/latest.dump