Geek asks and answers

Out-of-range timezone crowding out for heroku db: push, unable to resolve using ruby ​​1.9.2

This question was asked elsewhere, but it looks like the problem has returned and previous solutions no longer work.

The exception output is similar to:

Saving session to push_201205201307.dat..
!!! Caught Server Exception
HTTP CODE: 500
Taps Server Error: PGError: ERROR:  time zone displacement out of range: "2012-05-09 12:00:00.000000+5894536800"

I run postgresql 9.1 on ubuntu 12.04 and use cedar to the hero.

Other issues, such as Error when pushing data in Heroku: a timezone offset out of range shows that using rvm to switch to 1.9.2-p290 will correspond to the version working on the hero and avoiding the problem does not work for me.

Dropping values ​​in tables allows me to click data, but I'm looking for a more than one-time workaround.

pgbackups seems like this will work, but I would prefer not to set up another solid process to bypass using db: push.

Any suggestions? Is this really a problem with the cranes? The people here seem to have mixed results: https://github.com/ricardochimal/taps/issues/92

+3
source share
2 answers

It just worked after hours of frustration. I am disappointed jfeust did not give the gem tag that worked for it.

I have a pg database, so:

$rvm requirements

(install the dependencies and libraries before they cause you problems, and you cannot say why)

$rvm install 1.9.2-p318
$gem install heroku -v '2.2.8' --no-ri --no-rdoc
$gem install taps pg --no-ri --no-rdoc`

for recording my taps (0.3.24) and pg (0.14.1)

$rvm use 1.9.2-p318

This is what worked for me.

$~/.rvm/gems/ruby-1.9.2-p318/gems/heroku-2.2.8/bin/heroku db:push
+1
source

ruby ​​ . "heroku db: push" . , gem ( toolbelt), . , , db: push/pull .

0

More articles:


All Articles