How to use heroku postgres database locally.

When we work a project that is deployed on heroku, we need do use database locally. And heroku give the the option to download the database file as a dump file and use that on our local machine. In this tutorial we will see how we can download the database from heroku and use that in our development environment. Let's Start 🚀

The First Step is to login into heroku from local machine with heroku cli.

heroku login

Step - 2 (Capture and Download Backup with PGBackups)

To export the data from your Heroku Postgres database, we need to create a backup and download it to our local machine: we can do that with the following command.

Capture the data of our application

heroku pg:backups:capture --app example-app

Download the captured data

  heroku pg:backups:download --app example-app

replace your app name with example-app

with this a new file will be downloaded to your local machine, the file name will be something like latest.dump.

Step - 3 (Drop and recreate your existing database)

No we need to reset our local databases. run the following to command to reset.

rails db:drop

rails db:create

Step - 4 (Restore the database)

With the pg_restore tool we will restore the database to our app.

pg_restore --verbose --clean --no-acl --no-owner -h localhost -d mydatabase_development latest.dump

This will ask for the postgres database password. provide the pasword. and bang!

mydatabase_development is your local database name, you can get that inside config/database.yml file.

change mydatabase_development with your database name.

Step - 5 (Run Migration )

Now rum rails migration

rails db:migrate

It's all done. Now run the application. and all the data will be in your local site 😊😊😊.

Thank You.

Step -1 (Login to heroku)