Amazon RDS now supports PostgreSQL 9.6.1

#1

Post by rachbelaid » Tue, Nov 15, 2016, 2:17 AM UTC

Amazon RDS now supports PostgreSQL 9.6.1
postgresql.org

Re: Amazon RDS now supports PostgreSQL 9.6.1

#2

Post by tbrock » Tue, Nov 15, 2016, 2:31 AM UTC

This happened a couple days ago, noticed when spinning up a new RDS instance.

I'm super excited about it. It's great to have more modern managed services on AWS especially since this brings Postgres out of the Stone Age. Lots of good JSON support added in 9.5 and 9.6.

Previously only 9.4 was available.

Re: Amazon RDS now supports PostgreSQL 9.6.1

#3

Post by wasd » Tue, Nov 15, 2016, 2:33 AM UTC

I'm fairly impressed by RDS's turn around time. 9.6 dropped in late September and they're already supporting it in just over a month. I wish Google Cloud SQL supported Postgres at all. Sad that there's limited competition in managed postgres space (most notable competitor being Heroku).

Re: Amazon RDS now supports PostgreSQL 9.6.1

#4

Post by thejosh » Tue, Nov 15, 2016, 2:35 AM UTC

What's the performance of Amazon RDS like with Postgres? (Curious, never having used it).

Re: Amazon RDS now supports PostgreSQL 9.6.1

#5

Post by sheeshkebab » Tue, Nov 15, 2016, 2:37 AM UTC

thejosh wrote: post #4

What's the performance of Amazon RDS like with Postgres? (Curious, never having used it).

it's fine if you can leave with not doing any DBA stuff

Re: Amazon RDS now supports PostgreSQL 9.6.1

#6

Post by psycr » Tue, Nov 15, 2016, 2:38 AM UTC

Now they just need to support the Foreign Data Wrapper extension with egress connections. Really wish that was built in because FDW itself is amazing, and AWS RDS is easy to manage.

Re: Amazon RDS now supports PostgreSQL 9.6.1

#7

Post by psycr » Tue, Nov 15, 2016, 2:38 AM UTC

thejosh wrote: post #4

What's the performance of Amazon RDS like with Postgres? (Curious, never having used it).

You pay for the underlying instances + storage provisioning, so performance is price-configurable.

Re: Amazon RDS now supports PostgreSQL 9.6.1

#8

Post by bigdubs » Tue, Nov 15, 2016, 2:39 AM UTC

thejosh wrote: post #4

What's the performance of Amazon RDS like with Postgres? (Curious, never having used it).

It's basically what you get from a well configured EC2 instance.

Re: Amazon RDS now supports PostgreSQL 9.6.1

#9

Post by ramenmeal » Tue, Nov 15, 2016, 2:45 AM UTC

wasd wrote: post #3

I'm fairly impressed by RDS's turn around time. 9.6 dropped in late September and they're already supporting it in just over a month. I wish Google Cloud SQL supported Postgres at all. Sad that there's limited competition in managed postgres space (most notable competitor being Heroku).

Meanwhile, SQL Server on RDS doesn't support increasing the data allocation. You can't even take a snapshot and restore to a new, larger, RDS instance. Oh and by the way, SQL Server has been "supported" since 2012.

Obviously it's not their focus, but this is a fundamental selling point to cloud DB's.

Re: Amazon RDS now supports PostgreSQL 9.6.1

#10

Post by kstrauser » Tue, Nov 15, 2016, 2:45 AM UTC

And is it HIPAA certified yet? Because the lack of that is what made me spend a week porting a project to use RDS/MySQL just a little while ago. We've been told it's coming Real Soon Now since last year.

I wanted to use PostgreSQL for a whole host of reasons, but not so much that we wanted to certify our own instances.