TE
科技回声
首页24小时热榜最新最佳问答展示工作
GitHubTwitter
首页

科技回声

基于 Next.js 构建的科技新闻平台,提供全球科技新闻和讨论内容。

GitHubTwitter

首页

首页最新最佳问答展示工作

资源链接

HackerNews API原版 HackerNewsNext.js

© 2025 科技回声. 版权所有。

Amazon RDS for PostgreSQL

593 点作者 teoruiz超过 11 年前

38 条评论

adrianh超过 11 年前
This is HUGE!<p>I&#x27;m using the AWS stack for <a href="http://www.soundslice.com/" rel="nofollow">http:&#x2F;&#x2F;www.soundslice.com&#x2F;</a> and I&#x27;ve been using MySQL instead of Postgres, purely because my hatred for MySQL is less than my hatred for being a sysadmin. It was a tradeoff, and I miss Postgres dearly every time I use MySQL.<p>This new Amazon offering solves that.<p>I wrote a little more about my AWS setup here: <a href="http://www.holovaty.com/writing/aws-notes/" rel="nofollow">http:&#x2F;&#x2F;www.holovaty.com&#x2F;writing&#x2F;aws-notes&#x2F;</a>
评论 #6735056 未加载
评论 #6734603 未加载
评论 #6734311 未加载
评论 #6734099 未加载
评论 #6747412 未加载
评论 #6734208 未加载
yumraj超过 11 年前
I&#x27;ve heard about PostgreSQL and know that HN community raves about it, but am currently using RDS with MySQL.<p>Does it make sense to migrate to PostgreSQL, I don&#x27;t have a lot of data as I&#x27;m in the early stage? What are the primary advantages that PostgreSQL provides over MySQL? Any advise&#x2F;pointers is appreciated.
评论 #6733771 未加载
评论 #6733917 未加载
评论 #6733892 未加载
评论 #6733888 未加载
评论 #6733746 未加载
评论 #6736857 未加载
评论 #6736941 未加载
评论 #6734440 未加载
评论 #6734022 未加载
falcolas超过 11 年前
I have but one suggestion. Unless RDS for PostgreSQL is drastically different from RDS for MySQL, you still need a DB administrator.<p>RDS removes remarkably little of the pain of running a database instance (most of the pain that&#x27;s removed is just the up front setup), and ends up adding a lot of inconveniences for your day-to-day operations.<p>Also don&#x27;t count on their replication as your backup.<p>OK. That&#x27;s two suggestions, but I think it&#x27;s OK.
评论 #6739296 未加载
评论 #6734543 未加载
评论 #6734492 未加载
tracker1超过 11 年前
I think this is great news... PostgreSQL is definitively my favorite open-source database. It&#x27;s also nice to see Amazon get into the game, as hosted pg options have been fairly limited. I am slightly disappointed to not see the server-side JS support baked in, and that apparently you can&#x27;t do reads from distributed replicas. Just the same, I think there will be a lot of progress in this area.<p>Administering databases is a full-time type of responsibility. Yes, you can get pretty sane defaults, and up and running without much difficulty with MS-SQL, and mySQL has been a defacto standard in the LAMP stack. That said PostreSQL has been a rock solid RDBMS. The commercial extensions for replication have been cumbersome and expensive. Here&#x27;s hoping that AWS will grow&#x2F;expand the replications options&#x2F;features, and that they&#x27;ll grow to include JS procs as that feature stabilizes.
评论 #6736751 未加载
frakkingcylons超过 11 年前
I&#x27;d be most curious to know how the performance&#x2F;dollar ratio stacks up to Heroku&#x27;s Postgres offering.
评论 #6734566 未加载
thinkalone超过 11 年前
Here&#x27;s the announcement on the AWS blog - <a href="http://aws.typepad.com/aws/2013/11/amazon-rds-for-postgresql-now-available.html" rel="nofollow">http:&#x2F;&#x2F;aws.typepad.com&#x2F;aws&#x2F;2013&#x2F;11&#x2F;amazon-rds-for-postgresql...</a>
rachbelaid超过 11 年前
Great news and for people who ask them-self the questions but the version is Pg 9.3.1.<p>Not all Pl are available, and it misses the PL&#x2F;V8 and PL&#x2F;Python at least.<p>And it seems that all fdw (Foreign Data Wrapper) extensions are missing.<p>But it&#x27;s a great start, I&#x27;m looking forward to try.<p>If anybody know if we can still access the WAL log then it will be very useful<p><a href="http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_PostgreSQL.html" rel="nofollow">http:&#x2F;&#x2F;docs.aws.amazon.com&#x2F;AmazonRDS&#x2F;latest&#x2F;UserGuide&#x2F;CHAP_P...</a>
评论 #6734173 未加载
评论 #6735299 未加载
onedognight超过 11 年前
This is great news, but unlike for Amazon&#x27;s MySQL offering, they do not yet support read replicas for PostgreSQL.
评论 #6734288 未加载
评论 #6736072 未加载
ptio超过 11 年前
Great news! Now I don&#x27;t need to setup PostgreSQL myself.<p>Here is a related whitepaper if you still want to setup PostgreSQL yourself: <a href="http://media.amazonwebservices.com/AWS_RDBMS_PostgreSQL.pdf" rel="nofollow">http:&#x2F;&#x2F;media.amazonwebservices.com&#x2F;AWS_RDBMS_PostgreSQL.pdf</a>
revetkn超过 11 年前
Anyone know if the UUID type is supported? I see hstore and JSON are<p>Edit: It does, see <a href="http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_PostgreSQL.html" rel="nofollow">http:&#x2F;&#x2F;docs.aws.amazon.com&#x2F;AmazonRDS&#x2F;latest&#x2F;UserGuide&#x2F;CHAP_P...</a>
noviceapp超过 11 年前
Hmm, interesting development. But am I the only one to see a huge gap in services between Amazon and Heroku, and one which most certainly bodes bad for Heroku? Specifically, with Heroku&#x27;s recent PG 2.0 service, their &#x27;production grade&#x27; Standard plan ranges from $50 - $3500, but &quot;Up to 1 hr downtime per mo.&quot; ?!?1! Huh, really, with up to an hour downtime &#x2F;month, you couldn&#x27;t be serious about the product that runs atop this tier - a non starter me any most other SaaS businesses. Heroku&#x27;s cheapest &quot;high availability option starts at $200&#x2F;month, still with &quot;Up to 15 minutes of downtime per month.&quot;... still, this is a concern for me...<p>Now, comparing to Amazon, their &#x27;1.7 GB memory Small DB, 1-year reserved, multi-region&#x27; is around $28&#x2F;month (with storage &amp; transfer for my app no more $35&#x2F; month). The equivalent Heroku plan, Tengu (1.7 GB mem) STARTS at $350&#x2F;month!!! Wow, not I&#x27;m really rethinking my hosting platform.... Amazon looks more attractive, even if I have to do a bit of sys admin for my web server&#x2F;cloud server.
frankwiles超过 11 年前
Been waiting for this for a long time, can finally nudge our clients that want to use RDS (for various reasons) to use a sane DB. Thanks Amazon!
tzaman超过 11 年前
I guess now&#x27;s the time to start thinking about leaving Heroku...
评论 #6734110 未加载
评论 #6734242 未加载
jakozaur超过 11 年前
Wondering what is the easiest way to convert from MySQL RDS to Postgres. Any hints?
评论 #6734167 未加载
MrGando超过 11 年前
I think that the &#x27;simple monthly calculator&#x27; hasn&#x27;t yet included PostgreSQL instances?
评论 #6733669 未加载
michaelbuckbee超过 11 年前
How does this compare to Heroku&#x27;s PG offering?
评论 #6734056 未加载
评论 #6736385 未加载
jeffdavis超过 11 年前
Does anyone know if it&#x27;s pure community PostgreSQL or if there are modifications? If there are modifications, is it 100% compatible?
philliphaydon超过 11 年前
OMG I LOVE POSTGRESQL!!!!<p>This is awesome news! I hope we can move to it at work!
bmaeser超过 11 年前
this is awesome! still, i miss one essential feature - compared to mysql on aws and heroku&#x2F;postgres: there is no replication for read replicas. yes, you can deploy a &quot;hot standby&quot; replica in another availability zone for failover, but you cant read from it.
评论 #6733947 未加载
simonebrunozzi超过 11 年前
Useful tool to migrate from MySQL to PostgreSQL : <a href="https://github.com/lanyrd/mysql-postgresql-converter" rel="nofollow">https:&#x2F;&#x2F;github.com&#x2F;lanyrd&#x2F;mysql-postgresql-converter</a>
评论 #6736239 未加载
vocino超过 11 年前
This will make the ease of Elastic Beanstalk much more appealing.
kvinnako超过 11 年前
Somehow it seems pretty costly...Wouldn&#x27;t it be cheaper for me to just run it on my virtual instance that&#x27;s hosting the app and probably just back it up with S3.
评论 #6733864 未加载
评论 #6736469 未加载
victorhooi超过 11 年前
I&#x27;m curious what the performance characteristics of this would be like.<p>A lot of people talk about how poor the storage performance on AWS is - but this seems to offer provisioned IOPS up to 30,000 IOPS.<p>I&#x27;m curious what sort of hardware&#x2F;setup that translates to in the real world? Do you find your own dedicated setups have more throughput?<p>And there doesn&#x27;t seem to be much info on the network bandwidth between RDS and EC2 either.
taude超过 11 年前
We&#x27;ve moved off AMZN for more custom hosting. But this is a big win for open source devs. More deoployment options is always a good thing.
LVB超过 11 年前
I&#x27;ve only ever used S3, but some of these AWS offerings do look interesting for my little projects. My question is, how do hours get calculated for billing? If I had my super low traffic blog using RDS, would I incur a few microseconds of time per DB hit, or is it rounded up to an hour, or is it the total time the DB is available period?
评论 #6735225 未加载
benmathes超过 11 年前
Oh sweet, now I can actually put this up for less than $ArmAndALeg <a href="https://github.com/benmathes/earthquakes" rel="nofollow">https:&#x2F;&#x2F;github.com&#x2F;benmathes&#x2F;earthquakes</a>
workhere-io超过 11 年前
Note that AWS&#x27; PostgreSQL offering is more expensive than its MySQL counterpart.<p><a href="http://aws.amazon.com/rds/pricing/" rel="nofollow">http:&#x2F;&#x2F;aws.amazon.com&#x2F;rds&#x2F;pricing&#x2F;</a>
评论 #6737049 未加载
评论 #6736407 未加载
gfodor超过 11 年前
Oh dear god yes. I just rigged up a PostgreSQL instance on Ec2 for a new project, so excited to shut it down and let amazon deal with it. Hell yes.
nathanwdavis超过 11 年前
It doesn&#x27;t mention which version of PostgreSql. I hope it is 9.3. It&#x27;s got to be at least 9.2 since it supports the Json datatype.
评论 #6734533 未加载
adityamenon超过 11 年前
Oh, cool stuff! I&#x27;ll look into using this with the Openstreetmap deployment I&#x27;m building.
pkmishra超过 11 年前
This is so fucking awesome. I have been waiting for this since long time.
sjtgraham超过 11 年前
FINALLY!
lazyant超过 11 年前
Funny how it&#x27;s a tiny bit more expensive than the mysql counterpart
chenster超过 11 年前
Are they ever going to support DB2?
tomphoolery超过 11 年前
This is so nice. Thank you Amazon!
eonil超过 11 年前
Finally!
sillysaurus2超过 11 年前
Will anyone please explain the tactical reasons why PostgreSQL won? It&#x27;s pretty obvious it has. I&#x27;ve basically ignored the database wars for a few years, so it&#x27;s kind of interesting to see that everyone&#x27;s using PostgreSQL now.
评论 #6733908 未加载
评论 #6734385 未加载
评论 #6733726 未加载
评论 #6733745 未加载
评论 #6735387 未加载
评论 #6733717 未加载
评论 #6734396 未加载
评论 #6735952 未加载
评论 #6740623 未加载
评论 #6735317 未加载
评论 #6736210 未加载
评论 #6734256 未加载
评论 #6734009 未加载
评论 #6733751 未加载
natural219超过 11 年前
I hate PostgreSQL. Yes, I am a dummy application developer who doesn&#x27;t understand database software.<p>Every time I try to install PostgreSQL it fails. Every time I install MySQL it installs successfully with no problems. Actually, that&#x27;s the extent of my experience with it, and I guess I&#x27;m fine dealing with a database that doesn&#x27;t validate date formats strictly if I can <i>use the damn database without hassle</i>. I am totally fine using Postgres at a company or with another DB developer who knows how to set up databases properly, but if I am starting a new project, I am going to use MySQL, period.
评论 #6734585 未加载
评论 #6734143 未加载
评论 #6736352 未加载
评论 #6736549 未加载
评论 #6734388 未加载
评论 #6734604 未加载
评论 #6734142 未加载
评论 #6734851 未加载
评论 #6734157 未加载
评论 #6734621 未加载