3

I'm done with the pgbackups process.

First, I installed the pgbackups addon (HEROKU) via command: heroku addons:add pgbackups

Second, I login using heroku auth:login command

Third, I capture the backup by running the command: heroku pgbackups:capture --app myapp

Fourth, I get the url of the backup by heroku pgbackups:url b002

So I accessed the url that I saw after running the command: heroku pgbackups: url b002

in this format: https://s3.amazonaws.com/hkpgbackups/app2955630@heroku.com/b002.dump?AWSAccessKeyId=.......

something like that.

After that, I downloaded the file in .dump format

So now, I have the dump file and dont know what to do where to specifically use it...

Can somebody give me an advise to how to use the .dump file?

Please help me. I'm in trouble right now. I've to get a copy of our existing database from heroku.

rukia_kuchiki_21
  • 1,279
  • 3
  • 17
  • 34

1 Answers1

3

Your .dump file should be a pg_dump file so you'd need to set up PostgreSQL somewhere and then use pg_restore to load the .dump file into your local database.

mu is too short
  • 426,620
  • 70
  • 833
  • 800
  • I already have the dump file. But using pg_restore gives me a headache. It always says... pg_restore: [archiver (db)] connection to database "peekbox" failed: FATAL: password authentication failed for u ser "Rowell" – rukia_kuchiki_21 Jul 16 '12 at 05:17
  • @XirukiTepe: So you got it all figured out while I was away, right? – mu is too short Jul 16 '12 at 05:59
  • Yes. Thanks again. Now I have another query. And it's about Git clone command. There's a YOUR KEY WITH FINGERPRINT ........ is not authorized to access.... blah blah error. – rukia_kuchiki_21 Jul 16 '12 at 06:53
  • Will seek for an advise about that on the other question thread. Thanks. If you also know the answer about it, please do help me. ty – rukia_kuchiki_21 Jul 16 '12 at 06:54
  • If you know the answer please leave it here: http://stackoverflow.com/questions/11499481/your-key-with-fingerprint-is-not-authorized-to-access-myapp-the-remote THANKS – rukia_kuchiki_21 Jul 16 '12 at 07:01