Posted by Matt Soldo
At Heroku, we believe PostgreSQL offers the best mix of
powerful features, data integrity, speed, standards compliance, and
open-source code of any SQL database on the planet. That’s why we
were so excited to see the new release of PostgreSQL, version 9.0.1.
The release is described as “the most anticipated PostgreSQL version in five years” for good reason. The release adds over 200 new features and improvements. For more on PostgreSQL 9, see the coverage in Computerworld, Infoworld, and Linux.com as well as the discussion on Hacker News.
Today we are making PostgreSQL 9 available to all Heroku users through our public beta program. It is offered as a dedicated database with specifications identical to our existing Ronin plan. As a beta release, we do not recommend using this for production applications.
This is an excellent opportunity to test the compatibility of your schema and application code with PostgreSQL 9, and to try out its new features. Please note that our implementation does not yet support streaming replication or hot-standbys.
The beta will be available for free provided that you test its compatibility with your application and fill out this brief questionnaire . If you do not fill out the form we will charge the standard Ronin rate of $200 / month. The beta plan will be available for one month, after which we will ask users to migrate to non-beta plans.
To provision PostgreSQL 9 on a new application and restore a PG Backups database backup, use the following commands:
$ sudo gem install heroku # To install the latest version of the Heroku gem $ heroku addons:add heroku-postgresql:pg9test --app <your test app name> $ heroku pg:promote --db HEROKU_POSTGRESQL_PG9TEST_URL --app <your test app name> $ heroku pgbackups:restore `heroku pgbackups:url --app <your production app name>`
Give it a try and let us know what you think.