PostgreSQL has been embraced by many cloud providers this year like OpenShift, and VMware and others as platform for its database as a service offering. Heroku joins the list and launches PostgreSQL database as a service. Product manager Matt Soldo has said "Until now, the service has only been available to Heroku customers, but today we are pleased to announce the launch of Heroku Postgres as a standalone database service".
Included in this launch is a new web interface for managing databases, as well as rock-solid durability based on Continuous Protection technology. Best of all, these improvements are effective immediately for all existing users of the Heroku Postgres add-on.
Continuous Protection keeps data safe on Heroku PostgreSQL. Every change to your data is written to write-ahead logs, which are shipped to multi-datacenter, high-durability storage. In the unlikely event of unrecoverable hardware failure, these logs can be automatically 'replayed' to recover the database to within seconds of its last known state.
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 from any cloud platform, provisioned instantly, metered by the second, and without contract.
According to Matt, "Heroku Postgres has successfully and safely written 19 billion customer transactions, and another 400 million write-transactions are processed every day. Leverage Heroku’s scale and expertise while enabling your team to focus on building great apps rather than managing and configuring databases".
Heroku team are committed to running off-the-shelf, Community PostgreSQL - unforked and unmodified. Rest assured that any standard libpq client will run flawlessly on the service. Should you ever decide that you want to go back to being your own DBA, you can; there is no technical lock-in.