Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

Amazon RDS for PostgreSQL

aws.amazon.com

Post reply on HN
Print view View original

61–70 of 246 posts

Re: Amazon RDS for PostgreSQL

#61

Post by joyeuse6701 »

natural219 wrote: post #41

I hate PostgreSQL. Yes, I am a dummy application developer who doesn't understand database software. Every time I try to install PostgreSQL it fails. Every time I install MySQL it installs successfully with no problems. Actually, that's the extent of my experience with it, and I guess I'm fine dealing with a database that doesn't validate date formats strictly if I can use the damn database without hassle . I am tota…

I've had the exact opposite experience. I have only had nightmares installing MySQL.

Re: Amazon RDS for PostgreSQL

#62

Post by ancarda »

sillysaurus2 wrote: post #12

Will anyone please explain the tactical reasons why PostgreSQL won? It's pretty obvious it has. I've basically ignored the database wars for a few years, so it's kind of interesting to see that everyone's using PostgreSQL now.

I still use MySQL because trying out PostgreSQL recently scared me away. Maybe I was trying the wrong thing but I couldn't get pgAdmin to display my tables. I think I sank most of my afternoon trying unsuccessfully to do something MySQL can do in 5 minutes.

I recognize I'm used to MySQL but I was under the impression that because PostgreSQL has a similar syntax (SQL) it wouldn't take too long to pickup.

Re: Amazon RDS for PostgreSQL

#63

Post by timdorr »

skyebook wrote: post #57
onedognight wrote: post #18

This is great news, but unlike for Amazon's MySQL offering, they do not yet support read replicas for PostgreSQL.

Yeah I was disappointed to see this.. Can you configure pgpool externally to talk to the replicas or are those multi-az instances a black box? I've never used RDS before so I'm curious as to how much flexibility is afforded.

Unfortunately, no. Amazon RDS instances don't provide console access and are essentially black boxes.

Re: Amazon RDS for PostgreSQL

#64

Post by rektide »

yumraj wrote: post #8

I've heard about PostgreSQL and know that HN community raves about it, but am currently using RDS with MySQL. Does it make sense to migrate to PostgreSQL, I don't have a lot of data as I'm in the early stage? What are the primary advantages that PostgreSQL provides over MySQL? Any advise/pointers is appreciated.

If you didn't care yesterday, I HIGHLY ENCOURAGE AND RECOMMEND YOU NOT CARE TODAY.

Re: Amazon RDS for PostgreSQL

#66

Post by saltyknuckles »

pc86 wrote: post #40
adrianh wrote: post #4

This is HUGE! I'm using the AWS stack for http://www.soundslice.com/ and I'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. This new Amazon offering solves that. I wrote a little more about my AWS setup here: http://www.holovaty.com/writing/aws-notes/

Let me just say that I absolutely love soundslice. It's a great application!

Its actually really really impressive

Re: Amazon RDS for PostgreSQL

#67

Post by falcolas »

I have but one suggestion. Unless RDS for PostgreSQL is drastically different from RDS for MySQL, you still need a DB administrator.

RDS removes remarkably little of the pain of running a database instance (most of the pain that's removed is just the up front setup), and ends up adding a lot of inconveniences for your day-to-day operations.

Also don't count on their replication as your backup.

OK. That's two suggestions, but I think it's OK.

Re: Amazon RDS for PostgreSQL

#70

Post by cbsmith »

falcolas wrote: post #67

I have but one suggestion. Unless RDS for PostgreSQL is drastically different from RDS for MySQL, you still need a DB administrator. RDS removes remarkably little of the pain of running a database instance (most of the pain that's removed is just the up front setup), and ends up adding a lot of inconveniences for your day-to-day operations. Also don't count on their replication as your backup. OK. That's two suggesti…

As someone who is familiar with the rigamarole of PCI compliance, I respectfully disagree.
Post reply on HN