Heroku Blog

Postgres.app is the easiest way to get started developing with Postgres on the Mac. Open the app, and you have a local Postgres database ready and awaiting new connections. Close the app, and the server shuts down. It is available for free download today, and will be available on the Mac App Store pending Apple's approval. Postgres.app is designed so that most common programming libraries can find and it and link to it automatically – making it the easiest way to develop against Postgres on a Mac. It comes with the most popular Postgres libraries and extensions available right "out…

When was the last time you rotated your database credentials? Is it possible that old colleague still has access to your data? Or perhaps they've been accidentally leaked in a screenshot. There are many reasons to rotate your credentials regularly. We now support the ability to easily reset your database credentials, and it is as simple as running the following on your command line: heroku pg:credentials:rotate HEROKU_POSTGRESQL_COLOR –app your-app When you issue the above command, new credentials will be created for your database, and we will update the related config vars on your heroku application. However, on production databases (crane…

Six weeks ago we launched into beta the Heroku Postgres dev plan, a postgres 9.1 plan that offers many of the features of our production tier service. Over 3,000 of these dev databases are in active use, and it has been operating exceptionally well. When we launched the dev plan, we wrote that the plan would be limited based on rows rather than physical byte size. Today we are implementing a 10,000 row limit for the dev plan. This limit was chosen to correspond to the 5mb limit on the existing, shared database service. Over 98% of the active shared…