All posts tagged with postgres


Heroku Postgres Databases have been patched

Data is one of the most valuable assets of any company. As a database-as-a-service provider, one of our biggest responsibilities is ensuring your data is kept safe. A few weeks ago, one of the worst security vulnerabilities to date in PostgreSQL was discovered. To address this issue, Heroku deployed a point release upgrade across the entire Heroku Postgres service earlier this week. This resulted in a period of database unavailability, typically with a duration of less than one minute. Every database running on Heroku Postgres is now appropriately patched and is unaffected by the vulnerability.

PostgreSQL Vulnerability Details

The PostgreSQL...

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 Heroku Postgres, we believe that your data should flow like water. Only the most up-to-date data should be available any time you have a decision to make. Instead of being trapped in disparate systems, you should be able to move data smoothly...

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 results of that work in the form of extension support on Heroku and query cancellation. With the 9.2 release we're delighted to say that with your help, we've been able to bring you a whole host of new power and simplicity in your database.

Effective...

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 robust, and thanks to Heroku Postgres' cloud architecture, places no load on your primary database. Today, we’re announcing the release of this functionality into General Availability.

fork64

Forking your data opens up whole new ways of developing software. We've seen our users...

Announcing Follow

news

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 use cases:

One use case that has historically been challenging in database management is setting up a read replica, often referred to as a read slave....

Browse the blog archives or subscribe to the full-text feed.