New Heroku Postgres Plans GA

In past months we've release the public beta of our dev, basic, crane and kappa plans. We've received positive feedback from everyone using the new database plans.

Based on this strong positive response and adoption during the beta, we're officially moving these plans to general availability starting today.

In conjunction with the GA of our starter tier, we're deprecating our shared database plans. The new dev and basic plans offer many improvements including Postgres 9.1 with schemaless SQL, data clips, direct psql access, and a web management interface.

Beginning August 8, 2012, we will begin migrating shared database users over to the new starter tier. Users may control their application down time by migrating their databases ahead of August 8.

For steps in migrating to the starter tier please read here.

Release of new database plans on August 1st

We are happy to announce that our new line-up of database plans are being released on August 1st. The dev, basic, crane, and kappa plans make many of the most exciting features of our fully-managed database service available to a wider audience. They are now ready for all users.

We will also begin billing for these plans as of August 1st. If you have been beta testing one of these databases and do not wish to incur charges for it going forward, please remove it immediately via the web interface or the command line:

heroku addons:remove HEROKU_POSTGRESQL_COLOR --app app_name

If you have been waiting to use these plans because they have been in beta, then your wait is (almost) over. They can be provisioned now by all users via the web interface or the command line:

heroku addons:add heroku-postgresql:[dev | basic | crane | kappa]

Starter Tier

The dev plan (free) brings many of the best features of our production database plans to development users. This includes Postgres 9.1, data clips, hstore schemaless SQL, direct psql access, support for most pg commands from the Heroku client, a web interface, support for multiple databases connected to a single application, and Continuous Protection. The dev databases are limited to 10,000 total rows. For users that need to store more data, the basic plan ($9 / month) raises the row limit to 10 million rows but does not increase availability or add any additional features.

The dev and basic plans both belong to our Starter tier. These plans are designed to provide 99.5% availability and are ideal for trial, development, testing, and other basic usage. For serious production applications, we recommend using one of our Production plans, designed for 99.95% availability. Please note that these are design parameters, not SLAs, and availability can be further increased by taking advantage of followers.

Production Tier

With this release, the Production tier is expanded to include crane ($50 / month) and kappa ($100 / month). These will also be released on August 1st. They offer all of the same features as our other production databases at an incredible price point. These benefits include production-grade monitoring and operations, as well as support for fork, follow, auto backups, and fast changeovers / upgrades.

Migration From Legacy Shared Databases

For those users that are still using the legacy shared-database plan, we encourage you to upgrade as soon as possible. We will be announcing a deprecation and migration schedule for these plans shortly. We will be working to migrate all users onto these new plans, but we encourage you to move as soon as possible to enjoy the advantages of these improvements. You can also opt-in to creating the dev plan by default for all new applications by enabling the Heroku Labs flag.

If for any reason the scheduled release of these plans causes hardship for your business, please open a support ticket so that we can individually address your needs.

Release of new plans on August 1st

We are happy to announce that our new line-up of database plans are being released on August 1st. The dev, basic, crane, and kappa plans make many of the most exciting features of our fully-managed database service available to a wider audience. They are now ready for all users.

We will also begin billing for these plans as of August 1st. If you have been beta testing one of these databases and do not wish to incur charges for it going forward, please remove it immediately via the web interface or the command line:

heroku addons:remove HEROKU_POSTGRESQL_COLOR --app app_name

If you have been waiting to use these plans because they have been in beta, then your wait is (almost) over. They can be provisioned now by all users via the web interface or the command line:

heroku addons:add heroku-postgresql:[dev | basic | crane | kappa]

Starter Tier

The dev plan (free) brings many of the best features of our production database plans to development users. This includes Postgres 9.1, data clips, hstore schemaless SQL, direct psql access, support for most pg commands from the Heroku client, a web interface, support for multiple databases connected to a single application, and Continuous Protection. The dev databases are limited to 10,000 total rows. For users that need to store more data, the basic plan ($9 / month) raises the row limit to 10 million rows but does not increase availability or add any additional features.

The dev and basic plans both belong to our Starter tier. These plans are designed to provide 99.5% availability and are ideal for trial, development, testing, and other basic usage. For serious production applications, we recommend using one of our Production plans, designed for 99.95% availability. Please note that these are design parameters, not SLAs, and availability can be further increased by taking advantage of followers.

Production Tier

With this release, the Production tier is expanded to include crane ($50 / month) and kappa ($100 / month). These will also be released on August 1st. They offer all of the same features as our other production databases at an incredible price point. These benefits include production-grade monitoring and operations, as well as support for fork, follow, auto backups, and fast changeovers / upgrades.

Migration From Legacy Shared Databases

For those users that are still using the legacy shared-database plan, we encourage you to upgrade as soon as possible. We will be announcing a deprecation and migration schedule for these plans shortly. We will be working to migrate all users onto these new plans, but we encourage you to move as soon as possible to enjoy the advantages of these improvements. You can also opt-in to creating the dev plan by default for all new applications by enabling the Heroku Labs flag.

If for any reason the scheduled release of these plans causes hardship for your business, please open a support ticket so that we can individually address your needs.

Postgres.app - easy development with Postgres on a Mac.

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 Icon

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 of the box" including:

  • PostGIS 2.0 - Geospatial data and search.
  • PLV8 - JavaScript procedural language using the V8 engine.
  • hstore - Key-value data type.

Postgres.app supports Mac OS X Lion and Mountain Lion, and can be downloaded from http://postgresapp.com. It will also be available as a free download on the Mac App Store in the next couple weeks.

Our primary motivation for this project was to lower the barrier of entry for using Postgres, allowing more people than ever before to try out cool features like hstore, full-text search, window functions, and geospatial querying.

Another motivation for the project was to simplify achieving parity between development and production environments. The majority of active apps on Heroku use Postres, but we found that many developers use SQLite or MySQL on their local development machines. This can lead to subtle and hard-to-diagnose problems. Dev-prod parity is on of the best-practices set forth in The Twelve-Factor App and is an easy, low-cost way to enhancing developer productivity.

Created by Mattt Thompson, Postgres.app is an open-source project released under the PostgreSQL License. Source code is available on GitHub.

Whether you are a professional developer or just getting started, Postgres.app provides the best Postgres experience on the Mac..

Rotate database credentials on Heroku Postgres

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 HEROKU_POSTGRESQL_COLOR --reset --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 and up) we don't remove the old credentials immediately. Instead, we wait until all connections using the old credentials are dropped, and only then do we remove them. We wanted to make sure that any background jobs or other workers running on your production environment aren't abruptly terminated, potentially leaving the system in an inconsistent state.

Along with this change, we are removing credentials from the output of heroku pg:info, as we've seen that it has the most potential for credential leaking. To view connection information for your Heroku Postgres database you must simply ask by running heroku pg:credentials.

Both of these commands are available on all Heroku Postgres plans, from dev to mecha.

Finally, please update to the latest version of the Heroku Toolbelt to take advantage of this new functionality.

Browse the blog archives or subscribe to the full-text feed.