On Sun, Mar 6, 2011 at 10:56 AM, Hassan Schroeder < [email protected]> wrote:
> On Sun, Mar 6, 2011 at 8:40 AM, Bryan Crossland <[email protected]> > wrote: > > > Check your database.yml, Gemfile, and Gemfile.lock. Make sure you are > > specifying that you want to use PostgreSQL which is the database that > Heroku > > uses not SQLite3. > > Sorry, that's pointless. Heroku doesn't care about your database.yml > file at all. As long as you don't have any proprietary SQL statements > in your app or migrations, it should move between environments with > no issues. > > > You're (sic) development environment should match production the > > best that it can. > > Generally that's a good ideal to strive for, but with a cloud service like > Heroku it's irrelevant. I develop locally with MySQL and mongrel or > unicorn and push those apps to Heroku generally without issues. > > Far from pointless or irrelevant. I develop locally in MySQL pushed to Heroku, crash. PostgresSQL didn't play nice with the Rails migration statements for a column change. Fixed issue, pushed to Heroku, crash. Heroku didn't like the gem I had installed. Fixed issue, pushed to Heroku, crash. Heroku didn't like where SSL keys were stored or created. Fixed issue, pushed to Heroku, crash. Thin was more temperamental about code than Mongrel was. Worked in development and not in production. Why? Environment. You are setting yourself up for issue after issue when you assume that something should just work between environments with no issues. Environment is extremely important when developing. Just like a car chassis is not swappable with every type of car neither is the environment you create a program on. But in the absence of actual log data, who knows what's going on? :-) Agreed. Given what little has been presented from the log it points to attempts to load sqlite3 and use that over PostgreSQL. I wish I had the full log output to confirm. *cough* *cough* -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
