Matthew Soldo

Heroku is launching a new database backup solution. Heroku PG Backups is available immediately and is the officially supported and recommended method of backing up your PostgreSQL database on Heroku. PG Backups is a significant architectural improvement over Bundles and is designed to handle the large-scale, production databases that are being deployed to Heroku today. In addition to these backend improvements, PG Backups offers several new features: Backups are captured using pg_dump’s -Fc compressed format. This is the most reliable, fastest way of capturing backups from PostgreSQL. Data can be easily imported to your application – the pgbackups:restore command can…

Today Heroku is releasing an update to our dedicated database service. Heroku PostgreSQL provides an improved upgrade path for our users as their applications grow by offering new features, new plans, and instant provisioning. Product Improvements Direct database connectivity through psql (the Postgres command-line tool) or libpq (the Postgres client library). Direct connectivity makes it easier to introspect the database directly and run ad-hoc queries. It also enables complex, multi-application architectures with shared data stores. Instant provisioning and customer driven migrations. Previously, upgrading to our dedicated databases was a semi-manual procedure which required assistance from our support team and took…