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"

Answers


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.


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

1- Ruby, RVM, LLVM and MySQL

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


Need Your Help

Send email with attachment from android app using GMailSender fails at Transport.send

java android gmail email-attachments javax.mail

I am trying to send an email with an image as attachment from my android app. I have followed this post (among many others): Sending email with attachment through GMailSender?

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.