Pull in database from heroku to local

2

I need to synchronize my bank's data in production with what's in my location, is there any way I can pull the bank from heroku to mine in localhost without having to create a new bank locally? My application uses the Mercury editor, so the client can change some changes directly in production which means that almost every time I need to sync the banks, I did not want to have to create a new one every time I need to update my location. The bank used is the postgre

    
asked by anonymous 21.08.2014 / 21:42

2 answers

0

I downloaded the heroku dashboard itself, clicking on Databases you can download a snapshot from the database, the problem is that it comes in .dump format. To make this into a postgre format use the following command:

  

pg_restore --verbose --clean --no-acl --no-owner -h localhost -U userdobanco -d nicknameobanco filename.dump

    
21.08.2014 / 22:04
0

You can migrate to the database with Active Record to replicate your settings and then < a dump of the data to upload the records.

21.08.2014 / 21:53