John's right, and while the subject is at hand, I also would recommend running a Postgres per-project. Start Postgres something like this:
your_project $ initdb pg your_project $ postgres -D pg -p 5433 <in another tab> your_project $ createdb -p 5433 <database_name> your_project $ export DATABASE_URL=postgres://localhost:5433/<database_name> Now you can be sure your cluster for that Postgres database has nothing else interfering in it, the logs will show up in whatever tab you run "postgres" in, and you'll never have to mess around with pg_ctl or anything like that again. Way. Way. Way better. -pvh On Mon, Jan 23, 2012 at 2:31 PM, John McCaffrey <[email protected]>wrote: > You may want to just skip ahead and set up postgres locally, so that your > dev environment is as close to heroku as possible. > > 34% of problems that people have when starting with Heroku are due > entirely to not running postgres locally** > And when the problems do come up, its usually in a non-obvious, total pain > in the ass way > > **This statistic is totally made up, but feels about right, given this > mailing list, StackOverflow, and other people I've helped get set up on > Heroku. Maybe a more accurate number would be 34% of the issues I've dealt > with when helping people get set up... > > > On Mon, Jan 23, 2012 at 4:15 PM, Mark Pundsack <[email protected]> wrote: > >> The sqlite library is not available on Heroku. You might want to look at: >> http://devcenter.heroku.com/articles/how-do-i-use-sqlite3-for-development >> >> Basically, set the production environment to not load the sqlite adapter. >> Something like: >> >> group :production do >> gem 'dm-postgres-adapter'end >> group :development, :test do >> gem 'dm-sqlite-adapter'end >> >> Mark >> >> On Jan 13, 2012, at 9:39 PM, tripdragon wrote: >> >> I have a bare bones Sinatra app that is using >> gem 'dm-postgres-adapter' >> gem 'dm-sqlite-adapter' >> >> while running git push heroku master, I get http://pastebin.com/kcu6MAtt >> Installing do_sqlite3 (0.10.7) with native extensions Unfortunately, a >> fatal error has occurred. Please report this error to the Bundler >> issue tracker at https://github.com/carlhuda/bundler/issues so that we >> can fix it. Thanks! >> >> So I walked to that url to report this but it reported me to post >> here. >> https://github.com/carlhuda/bundler/issues/1488 >> >> On inspection of my Gemfile.lock I see that it's pointing to >> 0.10.6 and not the installed 0.10.7 as the log is writing. However >> chaging the Gemfile.lock to .0.10.7 and updating the git and push >> gives the same error >> >> Snipit of Gemfile.lock >> ___________________________ >> dm-sqlite-adapter (1.2.0) >> dm-do-adapter (~> 1.2.0) >> do_sqlite3 (~> 0.10.6) >> >> >> >> I would just use Postgres in development but I have not conqured that >> hurdle yet in getting that to work without some simple enough >> example. >> >> Thank you >> >> -- >> You received this message because you are subscribed to the Google Groups >> "Heroku" 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/heroku?hl=en. >> >> >> -- >> You received this message because you are subscribed to the Google Groups >> "Heroku" 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/heroku?hl=en. >> > > > > -- > Thanks, > -John > > -- > You received this message because you are subscribed to the Google Groups > "Heroku" 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/heroku?hl=en. > -- You received this message because you are subscribed to the Google Groups "Heroku" 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/heroku?hl=en.
