Postgres.app, an easier way to use PostgreSQL on Mac
My life just got easier thanks to Postgres.app (the easiest way to run #PostgreSQL on Mac) Thanks @craigkerstiens bit.ly/17jRh1a— Adam Stacoviak (@adamstac) June 3, 2013
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