how can use heroku db:push

Question

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"

see this https://github.com/ricardochimal/taps/issues/92 – Kyle Jan 23 '13 at 22:35 — Kyle, Jan 23 '13 at 22:35

score 1 · Accepted Answer · edited May 23 '17 at 10:34

1

Check out this solved SO question

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.

edited May 23 '17 at 10:34

Community

1
1

answered Jan 23 '13 at 22:36

Dan Hoerst

6,222
2
38
51

Right. It's believed to be an issue with the difference between the marshalling in Ruby 1.9.3 and Ruby 1.9.2. Switching to Ruby 1.9.2 should resolve your issue, or you can follow the above links for other possible options. – Dan Hoerst Jan 23 '13 at 22:40

score 0 · Answer 2 · answered Jan 23 '13 at 23:32

0

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

answered Jan 23 '13 at 23:32

OneChillDude

7,856
10
40
79

score 0 · Answer 3 · edited May 23 '17 at 12:26

0

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

1- Ruby, RVM, LLVM and MySQL

2- Error when pushing data to Heroku: time zone displacement out of range

edited May 23 '17 at 12:26

Community

1
1

answered Jan 24 '13 at 09:23

butb0rn

59
5

how can use heroku db:push

3 Answers3