Databases

An Update on the Updating of IBM Cloud Compose for PostgreSQL

Share this post:

Upgrading IBM Cloud Compose for PostgreSQL

If you haven’t upgraded your Compose for PostgreSQL deployment to the latest security-fixed version, we’ll be upgrading it for you in the coming weeks. Read on for how you can still take control of the upgrade.

A month ago, we made new versions of Compose for PostgreSQL available on IBM Cloud so that users could upgrade on their own schedule to the latest releases which resolved two security issues.

Now that a month has passed, we are moving onto the next phase of the process where we upgrade our customers’ databases for them. It’s important, for the Cloud’s version of herd immunity, to have the latest versions of databases in place, which is why we are taking this step. The timer begins today.

Your own timetable

You will still be able to do an upgrade yourself on your own timetable over this month. If you’ve been looking to move up a Compose for PostgreSQL major version, now could be a great time to do it. If not, you can do a simple in-place upgrade. It is important to remember that the in-place, minor version upgrades of the database have no application-level breaking changes.

Thirty days from now, on October 15th, we’ll be implementing forced upgrades of existing PostgreSQL’s up to the highest minor version for their major version. That means 9.4.x PostgreSQL will be upgraded to 9.4.19, 9.5.x to 9.5.14 and 9.6.x to 9.6.10.

We expect the upgrade work to be completed by mid-November.

Other benefits

There are added benefits to this upgrade for users too. We’ll be ensuring that all upgraded PostgreSQL deployments will be using Patroni as a core component of their high availability management. Patroni developed from a Compose project and replaced that project on Compose for PostgreSQL. If you have an older deployment, you’ll also find that you benefit from better more verbose logging.

Again, it’s not too late to take control of your own upgrade. Simply go to the Settings tab and select an in-place version upgrade for your database.

Other changes

We are also be moving the new PostgreSQL versions – 9.4.19, 9.5.14 and 9.6.10 – to preferred status, as previously announced. This will ensure that all new deployments will be using the latest version.

These changes will bring a better PostgreSQL to all Compose users.

Compose's Technical Content Curator

More Databases stories
January 16, 2019

Deploying Applications on IBM Cloud with Kubernetes and IBM Cloud Databases for PostgreSQL

Deploying a cloud-native application and integrating IBM Cloud Databases is easy using the IBM Cloud Kubernetes Service. In this tutorial, we’ll show you how to set up IBM Cloud Databases for PostgreSQL and deploy a Node.js application using the database with the IBM Cloud Kubernetes Service.

Continue reading

January 15, 2019

Using OpenStreetMap Data with IBM Cloud Databases for PostgreSQL

In this first part in a series dedicated to looking at geographical data, we're going to introduce you to OpenStreetMap data, import that data into an IBM Cloud Databases for PostgreSQL deployment, and make queries on some of the non-conventional data stored in hstore columns

Continue reading

January 3, 2019

Getting Started with pgRouting on IBM Cloud Databases for PostgreSQL

We're going to show you how PostgreSQL, PostGIS, and pgRouting on IBM Cloud Databases for PostgreSQL can get you started with complex geospatial queries.

Continue reading