Out of interest, do Amazon send anything upstream to the pg team?
Amazon RDS now supports PostgreSQL 9.6.1
21–30 of 83 posts
Re: Amazon RDS now supports PostgreSQL 9.6.1
#22Earlier quoted context omitted.
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.
That's pretty lame. Do you happen to know if you can you create an AAG with a larger volume on the replica and cut it over? I don't even remember if that's possible with your own SQL Server AAG, it's been a while. At any rate, thanks for commenting about this. I'm going to need to look into this at some point in the near future so your timing was fortuitous.
I'm assuming MS SQL? Isn't much cheaper to run it on an instance yourself if you have company licenses? And I suspect people who don't already have licenses run postgres or mysql.
Re: Amazon RDS now supports PostgreSQL 9.6.1
#23Earlier quoted context omitted.
That's pretty lame. Do you happen to know if you can you create an AAG with a larger volume on the replica and cut it over? I don't even remember if that's possible with your own SQL Server AAG, it's been a while. At any rate, thanks for commenting about this. I'm going to need to look into this at some point in the near future so your timing was fortuitous.
I'm assuming MS SQL? Isn't much cheaper to run it on an instance yourself if you have company licenses? And I suspect people who don't already have licenses run postgres or mysql.
Yep, MS SQL Server. I think that's something you have to determine on a case-by-case basis. If you have Software Assurance you can run it on any instance but if you don't you have to pay Amazon for dedicated hardware. As usual Microsoft's enterprise licensing is pretty much shit. You might also incur more operations overhead than you can afford by having to deal with patching, outages, performance degradation, etc. And your management might want to engage in a slide deck circle jerk with animations about how modern and in the cloud you are by using RDS so that's worth throwing a few $30K+SA enterprise proc licenses away.
Re: Amazon RDS now supports PostgreSQL 9.6.1
#24Now 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.
Agree 100%. Would be awesome if you could have RDS with FDW connected to a Redshift instance. (don't know if that's possible given the version of Postgres upon which Redshift is based)
You can definitely do FDWs to Other Postgres instances, and since I think you can just point the same wrapper to redshift and voila.
Re: Amazon RDS now supports PostgreSQL 9.6.1
#25Does this indicate if it will include a REST API to build some quick applications off of or is it easier to return a JSON from a query?
Re: Amazon RDS now supports PostgreSQL 9.6.1
#26This 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.
9.5 was actually added to RDS back in April [0]. There was some serious bugs found that made them wait for 9.5.2 before adding it [1]. As a customer of RDS, I'm really happy that they're taking their time to thoroughly test the releases. [0] https://aws.amazon.com/about-aws/whats-new/2016/04/rds-postg... [1] https://forums.aws.amazon.com/thread.jspa?threadID=240278
Yeah they only added 9.5 a couple weeks ago, very recently.
Re: Amazon RDS now supports PostgreSQL 9.6.1
#27Does anyone else have abysmal IO performance on postgres RDS? I have a 200 gb provisioned ssd with 2000 iops and get abysmal bulk read performance - the panel will report 30 mb/s and query speed is really slow with disk being the bottleneck
Any indexes on the table? Are you using COPY, INSERT INTO or /COPY via PSQL?
Re: Amazon RDS now supports PostgreSQL 9.6.1
#28And 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.
Although dirty, you could still technically use Postgres I believe, you would just need to run it on EC2 and EBS instead. The covered services for the BAA include EC2 and EBS, so you would still be covered under the signed BAA with Amazon. When it is eventually covered under the BAA, you could port over to Postgres RDS.
Re: Amazon RDS now supports PostgreSQL 9.6.1
#29And 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.
Another option is to use Aptible: https://www.aptible.com/
It's basically (a better) Heroku with an emphasis on enabling HIPAA/HITECH compliance. They do both app and DB hosting (including Postgres). And it's on AWS so integrates easily with existing infrastructure/code.
Disclaimer: Biased as I know the founders and we use the product. But they are good people and it's a good product!
Re: Amazon RDS now supports PostgreSQL 9.6.1
#30On a slightly tangential topic, what is Amazon doing with aurora?
So far good things IMO. Released a new version recently, the performance has been outstanding.