Heroku Postgres

Introducing the newest plan in the Heroku Postgres line-up: dev. It is an updated replacement for the PostgreSQL 8.3-based shared database add-on. This plan is available immediately in public beta:

$ heroku addons:add heroku-postgresql:dev

It can also be provisioned through the Heroku add-ons catalog.

What's New?

This new dev plan offers increased parity between our free database service and our paid, production plans. New features include:

• Postgres 9.1
• Data clips
• hstore
• Direct database access from
…

Today has been a very good day for Postgres.

We here at Heroku love Postgres, and we aren’t afraid to show it. Here’s how three different Herokai showed their PG love in three awesome ways in the last 24 hours:

Postgres.app is the easiest way to run PostgreSQL on the Mac. Just open the app, and you have a server up and running with Postgres 9.1 and PostGIS 2.0. PostgreSQL has not been the easiest …

One of the great strengths of PostgreSQL is extensibility. Just as the JVM has become more than a way to just run Java—spawning languages such as Clojure and Scala—PostgreSQL has become more than just a home to relational data and the SQL language. Our first officially supported Postgres extension, hstore, enables you to build better apps faster without sacrificing the power, reliability, and flexibility of the underlying PostgreSQL storage engine.

By using hstore, you …

We’re constantly involved in improving Postgres on behalf of our users. That kind of work includes building new features into our platform like data clips, tracking down bugs uncovered by our users and getting them fixed, and working to bring the needs of our users to the attention of the developer community driving the project forward.

Of course, all that pales in comparison to the work the community does every day, and there’s no bigger …

Data clips are available today in beta as a standard feature on all Heroku Postgres databases.

When we share information on the Internet, we do so by sharing URLs. We send URLs for locations, books, videos, and even source code. Until now there hasn't been a convenient way to share data inside a database. That's why we're introducing Data Clips. They are a fast and easy way to unlock the data in your …

At the Heroku Department of Data, we are always investigating ways to improve the reliability, security and performance of your database servers. We do this by monitoring the entire ecosystem around it; we monitor the reliability of the platform itself, as well as keeping a close eye on the hardware where your data is hosted on upstream servers. But this also includes listening to the community. We do that by staying involved with our users …

One of the benefits of consuming a database through Heroku Postgres is that we are continually improving the service. This benefit is compounded by the fact that our service is based on PostgreSQL, a vibrant and active open source project. The release of PostgreSQL 9.1 had added a number of feature, performance and reliability improvements. These are available today with our beta support for PostgreSQL 9.1.

We have been testing and watching PostgreSQL …

Until now, Heroku’s Postgres database service – originally launched in 2007 – has only been available to Heroku customers for use with Heroku platform apps. Today we’re excited to announce the launch of Heroku Postgres as a standalone service.

With measured service uptime of four nines (99.99%), and designed data durability of eleven nines (99.999999999%), the service is trustworthy for mission-critical data. As of today, these production-quality Heroku Postgres databases are independently available for use …