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 be expanded.

Today we are releasing support for 16 new Postgres extensions which add exciting new functionality including the ability to query from multiple database (dblink), a...

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 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...

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...

Postgres.app is the easiest way to get started developing with Postgres on the Mac. Open the Postgres app, and you have a local Postgres database ready and awaiting new connections. Close the app, and the server shuts down. The macOS PostgreSQL app is available for free download today.

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 - Geospatial data and search.
• PLV8 - JavaScript procedural language using the V8 engine.
• hstore -...

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 and up) we don't remove the old...