Now Available: Auto-scaling PostgreSQL Deployments

The eagle-eyed amongst you will have noticed some changes on the deployment dashboard and deduced that we have an announcement to make. And we do - Compose is now hosting PostgreSQL databases. Using the same technology that makes our MongoDB's elastic, our ElasticSearch's springy, our RethinkDB's ready and our Redis's rapid we're bringing PostgreSQL, our first relational database, to the Compose cloud.

We've been looking at bringing an SQL database onboard for some time and the release of PostgreSQL 9.4 was an important waypoint in that journey. As version 9.4 developed we could see the sturdy, well-tested relational database was getting features like replication slots, so we could deliver the reliable, high-availability database we want to deliver, and JSON-B, a binary version of JSON for optimal document storage, which would make PostgreSQL fit comfortably alongside MongoDB, Elasticsearch, Redis and RethinkDB.

We set about delivering PostgreSQL to the same high standard we deliver all our databases. We give you admin access so you have complete control and can create as many databases as you need on your PostgreSQL deployment. That deployment consists of two instances synchronized with slotted replication, managed by an etcd host and accessed through a connection-routing TCP access portal. It includes our backup systems for no-stop automated backups and it's all wrapped up in the Compose dashboard.

3

So, if you want to add PostgreSQL to your Compose databases, just go to Add Deployments on your dashboard, select Beta PostgreSQL and name your new deployment. If you don't have an account you'll be up and running in minutes when you sign up. It'll be even quicker if you've already got an account with Compose because you can go straight to PostgreSQL deployment from here.

Thanks to elastic scaling you can start at $17.50 per month for 1GB of storage and each extra GB of storage costs just $12 a month letting you get exactly as much PostgreSQL as you need. As with all new database rollouts at Compose, this is a beta where we will attempt to maximize uptimes, but offer no guarantees.

Do you want to know more? Read Seven Things You Probably Didn’t Know About Compose’s Auto-Scaling PostgreSQL which has a lot more detailed information.