Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

how to install pg_dump and pg_restore to the heroku

Tags:

heroku

I have to load pg_dump and the pg_restore to Heroku so that I can load a local database to Heroku. How can I install pg_dump and pg_restore on Heroku? What are their addresses?

like image 509
nesAM Avatar asked Nov 02 '22 21:11

nesAM


1 Answers

So they way Heroku works is you install an addon to your Heroku app called Heroku Postgres. Then you add another app called PGBackups. These apps expose commands to your command line. They are like subcommands to the heroku command. So you'd do heroku pgbackups:restore to restore (or really, load initially) a database to your Heroku instance. See this link:

https://devcenter.heroku.com/articles/heroku-postgres-import-export

like image 79
TerminalDilettante Avatar answered Nov 08 '22 14:11

TerminalDilettante