Heroku Postgres

An organization’s data is its most valuable asset. Unfortunately, that data is usually trapped inside a database with few ways to access it by a privileged handful of people. Too often reports are manually generated and their results pasted into emails; dashboards get built but rapidly become outdated and never answer the right questions.

We have so many great tools for collaborating around our source code, why is data still in the dark ages? At …

Hosting your data on one of the largest fleets of databases in the world comes with certain advantages. One of those benefits is that we can aggregate the collective pain points that face our users and work within the Postgres community to help find solutions to them.

In the previous year we worked very closely with the broader Postgres community to build features, fix bugs, and resolve pain points. You've already seen some of the …

Git and Github revolutionized software development by letting you fork your source repository with a single click. Wouldn't it be great to be able to do the same thing with your database?

In the same way you can fork your code you can now fork your data. Fork changes the way you can work with your data, making it a snap to provision a clone of your production database. The technology is simple, safe, and …

Today we’re releasing the ability to follow your Heroku Postgres Database into General Availability: this lets you easily create multiple read-only asynchronous replicas of your database, known as followers.

After an extended beta period during which over 3,000 followers were created, many of which help power core Heroku systems, we’re excited to make the ability to safely and easily scale out access to your data available to all Heroku Postgres users.

Followers enable some great …

Databases are the well known solution for storing data for your application. However they sometimes lack functionality required by application developers such as data encryption or cross database reporting. As a result developers are forced to write the needed functionality at their application layer. Postgres 9.1, which already has an extensive collection of data types and functions, took the first step towards mitigating this by creating an extension system which allows the database’s functionality to …

In past months we’ve released 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.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 …

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, …

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 …

Last week we launched our dev plan, a free database designed for development and testing. Today, we are launching into public beta two new plans: Crane and Kappa. These plans are part of our production tier, offering the same monitoring, operations, support, and data protection features as our more expensive plans.

Crane is available for $50 per month and features a 400 mb cache. Kappa is $100 per month and features a 800 mb …