Search code examples
rubyherokupullsequelsqlite3-ruby

Heroku db:pull error LoadError: cannot load such file — sqlite3 (Sequel::AdapterNotFound)

I'm having the same problem as this person: Heroku db:pull error "LoadError: cannot load such file -- sqlite3 (Sequel::AdapterNotFound)" Where I cannot pull my database from heroku. However gem install sqlite3, gem install taps, and installing heroku toolbelt did not solve the problem in my case. Do I need to install something else?

I don't know if this affects the problem, but I have 2 apps on my local machine. Each logs into a different Heroku account, each Heroku account has a different login email address. I'm logged into the Heroku account with the database I want. When I enter git remote -v, the correct app name is returned. So I'm pretty sure my local computer is trying to to access the correct database on heroku.

Solution

  • I was able to get a .dump file of my old database with pgbackups, then was able to convert to a text file with pgAdminIII.