How to move from Amazon RDS to a dedicated PostgreSQL server • Hacker News Board

Re: How to move from Amazon RDS to a dedicated PostgreSQL server

#71

Post by oskari » Wed, May 25, 2016, 7:33 PM UTC

gingerlime wrote: post #70

oskari wrote: post #65

Earlier quoted context omitted.

FYI, the Aiven database service allows you to run multiple database per instance. HA plans for Aiven start at US$200/mo and are available in multiple clouds including AWS and Google, see https://aiven.io/postgresql#comparison

First to hear about Aiven and you guys released pg hoard. Right? Interesting offerings. Are you connected to upcloud? (Both are based in Helsinki from what I could gather)

Yeah, PGHoard is the PG cloud backup solution we initially developed for Aiven and later open sourced. It's now used in a lot of other environments as well.

Aiven services are available on UpCloud and we're friends with the UpCloud people as we're both based in Helsinki and have met at various events, but there's no other connection between the companies.

Re: How to move from Amazon RDS to a dedicated PostgreSQL server

#72

Post by askldfhjkasfhd » Wed, May 25, 2016, 8:00 PM UTC

qaq wrote: post #24

audleman wrote: post #23

Earlier quoted context omitted.

My 2 cents: you're promising a lot more for the same price which seems dubious. How are you going to beat the wholesaler? Even if you did I probably wouldn't use it. I don't want a 3rd party dependency on the most critical part of my infrastructure.

The price would be comparable to AWS appropriate tear eg 6TB storage for a bit less (10-15%) then amazon's 6TB RDS option but with much better performance. I totally get your reluctance to rely on 3rd party, but the question is more for people who already do rely on 3rd party such as AWS or Azure.

> I totally get your reluctance to rely on 3rd party, but the question is more for people who already do rely on 3rd party such as AWS or Azure.

Just a little input: Amazon and Microsoft are well known companies. I (and my superiors) think they can support us. Your company that I haven't heard of is not.

It may be dumb sounding, but I won't get in trouble if I used AWS and something went wrong. How could I have known?

With an unknown company, if something goes wrong, it's on me because I selected that vendor.

Stupid perhaps, but important to understand.

Re: How to move from Amazon RDS to a dedicated PostgreSQL server

#73

Post by Jweb_Guru » Mon, May 30, 2016, 4:20 PM UTC

qaq wrote: post #67

adwf wrote: post #59

Earlier quoted context omitted.

My priorities are: Reliability > Size ~= Price > Performance Reliability of a database is always no.1, without it, nothing else matters. So the customer must have enough access to the machine to setup replication and failover themselves (eg. using something like repmgr). Or have damn good guarantees that you're doing it well for them. ie. multiple replicas, verifiable backups, offsite backups, etc. Secondly is size.…

Thanx for your input many of the frustrations you outline is the exact motivation why we are considering building this service.

I can tell you what I really want out of a managed Postgres provider. It has nothing to do with anything that was listed: it's configurability. None of the managed providers allow me access to many of Postgres's features, like custom full text dictionaries or third-party extensions, which is a real shame because those are some of its biggest differentiators. I would use a managed service that offered those things in a heartbeat.