Geek asks and answers

Heroku db: trouble pressing

I am trying to push my local Postgres db to my Heroku application and following the Heroku manual I did heroku db:push, but I got the following error:

leonsas@leonsas-VirtualBox:~$ heroku db:push
 !    Taps Load Error: cannot load such file -- sqlite3
 !    You may need to install or update the taps gem to use db commands.
 !    On most systems this will be:
 !    
 !    sudo gem install taps

I already tried sudo gem install taps, sudo gem install sqlite3but I can't get it to work. Any ideas why it is trying to load sqlite3 db when I use postgres?

+5
source share
1 answer

Waste is no longer the recommended tool to use when transferring data between postgres instances. Instead, heroku-pg-transfer .

, Heroku postgres dev. , .

URL- db Heroku:

$ heroku config:get DATABASE_URL
postgres://yada:yada@ec2-107-21-122-141.compute-1.amazonaws.com:5432/123

db heroku db:

$ heroku plugins:install https://github.com/ddollar/heroku-pg-transfer
$ heroku pg:transfer -f postgres://localhost/dbname -t postgres://yada:yada@ec2.../123

heroku-pg-transfer pg_dump postgres, .

+14

More articles:


All Articles