PostgreSQL 9.5 now on Compose

PostgreSQL 9.5 is now available with Compose. To be precise, PostgreSQL 9.5.2, the very latest release is now available on Compose.

We've been tracking PostgreSQL 9.5's development since last May, testing out upsert and many more of its new features. Since 9.5 became generally available in January, we've been making sure that it works well on the Compose platform.

Now, with our testing complete, and with the release of an important update for PostgreSQL 9.5, we're ready to give you the latest PostgreSQL version: 9.5.2. Let's have a quick look at some of the new features in PostgreSQL 9.5:

There are many more enhancements in the 9.5 release than what we've touched on here. Importantly though, one feature Abbreviated Keys mentioned there has just been removed in PostgreSQL 9.5.2, at least for the forseeable future, because of a problem with consistency of string compression in glibc which it relied on.

Over the next few days, and weeks, we'll be taking a deeper look at some of these new features so you can take full advantage them.

Availability

PostgreSQL 9.5.2 is now available for new PostgreSQL deployments on Compose. Existing Compose PostgreSQL 9.4 users will have an in-place upgrade option available to them soon. We're currently testing our making the process to ensure it is as reliable as possible.

If you can't wait for the 9.5 in-place upgrade option, remember you can bring up a new 9.5 deployment and then use pg_dump on your 9.4 databases to create backup files and psql to restore those backups into your 9.5 database.

Coming Next

There's lots of exciting new features to explore on Compose PostgreSQL and in the coming days and weeks, we'll be looking at how you can make best use of them. We'll also be tracking the development on 9.6 in Compose's Little Bits (every Friday on Compose Articles) and in future articles.