Skip to content

Instantly share code, notes, and snippets.

@trey

trey/heroku_db_pull.md

Created October 14, 2012 21:09
Show Gist options
  • Save trey/3889821 to your computer and use it in GitHub Desktop.
Save trey/3889821 to your computer and use it in GitHub Desktop.
Download ZIP
Getting `heroku db:pull` to Work
Raw
heroku_db_pull.md

Getting heroku db:pull to Work

$ rvm install 1.9.2
  • I had to do this business per the instructions I saw when I ran that command:
$ brew update
$ brew tap homebrew/dupes
$ brew install autoconf automake apple-gcc42
$ rvm pkg install openssl
$ rvm reinstall all --force
  • Use Ruby 1.9.2
$ rvm use 1.9.2
  • Install heroku, taps, pg, and sqlite3 (for some reason)
$ gem install heroku
$ gem install taps
$ gem install pg
$ gem install sqlite3

There. Now you can do something cool like:

$ heroku db:pull postgres://localhost/yourdatabase

You should not have to use sudo on any of those commands.

It took me a long time to realize that I needed to use Ruby 1.9.2 to get this to work.

@will
Copy link

will commented Sep 3, 2013

I've made what will soon be the replacement for taps/db:push/pull, and I'm going around the information superhighway looking for people who have had problems with taps to get feedback before it's released for real. Check out heroku/heroku-pg-extras#42

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment