Using heroku pg:pull to restore a backup to a macOS laptop
Today I worked out how to use the Heroku command and Postgres.app to pull a Heroku backup to my laptop.
3 posts tagged “heroku”.
Today I worked out how to use the Heroku command and Postgres.app to pull a Heroku backup to my laptop.
Figured this out in https://github.com/simonw/simonwillisonblog/issues/132 - I was running PostgreSQL 9.x and I wanted 11.x in order to use the new option in Django 3.1.
My db-to-sqlite tool can connect to a PostgreSQL database, export all of the content and write it to a SQLite database file on disk.