how can use heroku db:push
I have a Ruby 1.9.3p194/Rails 3.2.7 application. I want to push my local database to heroku. I use heroku db:push but I get these errors:
Schema: 100% |==========================================| Time: 00:00:11 Sending indexes schema_migrat: 100% |==========================================| Time: 00:00:02 Sending data 5 tables, 30 records magazines: 0% | | ETA: --:--:-- Saving session to push_201301231426.dat.. !!! Caught Server Exception HTTP CODE: 500 Taps Server Error: PGError: ERROR: time zone displacement out of range: "2013-01-23 12:00:00.000000+5895158400"
Are you using Ruby 1.9.3-p0? Apparently switching to 1.9.2-p290 will resolve the issue.
Otherwise, check out this Github issue.
This is an issue that many people are experiencing. Switching versions didn't do it for me, I had to use another fix found here: Issue on Github
First I install rvm use ruby-1.9.2-p290 but I have a mac os and it has problems so you can install new ruby verion on rvm like this rvm use ruby-1.9.2-p290 --with-gcc=clang after you install ruby , you need to install taps , after that you can use heroku db:push