Amazon RDS now supports PostgreSQL 9.4.1

http://aws.amazon.com/about-aws/whats-new/2015/03/amazon-rds-for-postgresql-now-supports-94/

by endymi0n • 11 years ago

131 26 11 years ago

aws.amazon.com

endymi0n2• 11 years ago

We've been waiting for JSONB support quite some months now, great that it finally arrived in AWS. Dumb question now: Anyone knows how to upgrade 9.3 machines?

jpgvm2• 11 years ago

Are you talking about RDS or your own 9.3 to 9.4 upgrade?

If the former, then unfortunately the only option is a database dump followed by creating a new RDS instance and then restoring.

As for the latter you can do an in place upgrade following the PG docs.

endymi0n2• 11 years ago

So it's basically standstill? Create new instance, halt all processes, migrate the data, delete old one? Sounds sad, but if it's the only way to go, I'll go ahead. Anyone want to share experiences scriptingwise?

dankohn1• 11 years ago

I was very unhappy to find that RDS does not support cross-region read replication for Postgres, only for MySQL. We had made a significant investment to migrate from MySQL to Postgres but are now having to back out a lot of changes, because we need that redundancy.

Postgres is widely acknowledged as the leading open source database. It's frustrating that it remains a second class citizen on AWS.

https://forums.aws.amazon.com/message.jspa?messageID=604244

dijit2• 11 years ago

I definitely share your sentiment, but AWS is geared mostly towards developers, and mysql is the leading database in terms of users.. especially among the legacy development community. (those that did LAMP in the 00's and do not wish to relearn databases)

netcraft2• 11 years ago

I'm not doubting you, but do you have any sources for user counts for different database types? I get the same sense, but I wonder what the numbers are really like.

Ixiaus• 11 years ago

But they do support read replicas, surely cross region read replicas is coming soon?

darkr• 11 years ago

They only launched support for within-region read replicas back in November > https://aws.amazon.com/blogs/aws/rds-postgres-read-replicas/

Postgres is still comparatively new to AWS, whereas MySQL was one of the first (the first?) supported RDS engines way back in 2008/9 or thereabouts. I guess this is due in part to the relative latecoming of built-in streaming replication support in Postgres, it's only been since 9.0 that it's been a thing, and 9.1 that it's been production-ready, which coincides with it's rise in popularity over recent years (well, that and Oracle buying Sun..).

My money is on support for x-region replication being announced late this year; it's a feature I'm interested in for sure.

sciurus3• 11 years ago

Why not run your own Postgresql installations instead of relying on RDS?

smt882• 11 years ago

Scaling, backing up, and replicating database hardware is a huge pain. RDS does all of that. For small companies, the extra cost is more than worth the time savings.

Plus it's all hooked into the rest of the AWS system, which can be really helpful.

tgeek• 11 years ago

Calling Postgres the leading open source DB is probably a bit more than a stretch these days, but yes its quite popular with startups(though one would argue nosql DBs are #1 in the eyes of most startups sadly). Unfortunately one of the places its not popular in, is Amazon and the majority of their business customers. MySQL, Oracle, and SQL Server are all much more popular than Postgres, which is why they have probably focused on it more over the years. That said, the features have seemed to be coming pretty regularly.

earless1• 11 years ago

Before cross region replication was available for MySql we use to just ship our snapshots to our failover region. We also stood up an EC2 MySQL instance as a slave to the RDS instance in our primary region. This approach allowed us to use RDS back then and still be capable of a regional failover within a reasonable amount of time.

alpeb• 11 years ago

JSONB is nice, but the inability to perform updates inside a JSON doc is major drawback.

thomasfoster96• 11 years ago

I suppose PL/V8 ( which RDS has installed by default) would make it trivial to write a function to do this - you'd be able to do anything with JSON in postgres that you can in Node.js or the browser.

Amazon RDS now supports PostgreSQL 9.4.1

Related Stories