Adam Stacoviak changelog.com/posts

Postgres.app, an easier way to use PostgreSQL on Mac

A week or so back, I was chatting with Craig Kerstiens, a product guy at Heroku, about an issue I was having with my Postgres install (through Homebrew) -- he suggested that I use Postgres.app.

There's an easier way

Just download, install and run the app when you want to run Postgres locally for development. I always found myself fumbling with commands like pg_ctl -D /usr/local/var/postgres start or pg_ctl -D /usr/local/var/postgres stop -s -m fast to start and stop my Postgres server. Running Postgres.app is a much simpler and easier user experience now. Just run the app when you’re hacking, and quit the app when you’re done. Simple.

The classic Postgres elephant icon will hang out in your system tray for easy access.

Heroku and Rails specifics

If you’re hacking on a project and deploying to Heroku with a Postgres database, you’ll need to run heroku addons:add heroku-postgresql:dev to setup Postgres for your app before running something like heroku run rake db:migrate.

For more details on using Postgres on Heroku check out postgres.heroku.com. You should also subscribe to Postgres Weekly - a free, once–weekly e-mail round-up of PostgreSQL news and articles curated by Craig Kerstiens.


Discussion

Sign in or Join to comment or subscribe

Player art
  0:00 / 0:00