How to get your data from Heroku PostgreSQL database

First get data out (DUMP_FILE):

1. Dump database to Heroku servers:

heroku pg:backups capture --app HEROKU_APPLICATION_NAME

2. Generate download URL:

heroku pg:backups public-url -a HEROKU_APPLICATION_NAME

Next store it to your database:

pg_restore --no-owner -d DB_NAME -U DB_USER < DUMP_FILE

© Jiri Pinkas | this project on GitHub | related: JavaVids | Maven Central Repository Search | Java školení

Top Java Blogs is a Java blog aggregator (with English-written blogs only) focused on Java SE, Java EE, Spring Framework and Hibernate.

Made better & faster using https://www.yourkit.com/ Java Profiler