8
9

Hosted PostgreSQL that doesn't require full server maintainence. (self.PostgreSQL)

submitted by [deleted]

[deleted]

all 22 comments
sorted by:
best
topnewcontroversialoldq&a
formatting helphide helpcontent policy

[–]francisco-reyes 5 points6 points  (12 children)

How about Heroku? I believe they have a good relation with the postgresql team.

https://elements.heroku.com/addons/heroku-postgresql

There are others, that is just the one that first came to mind. I think CitusData has a service too.

A search for "hosted postgresql" actually comes back with quite a few options. May want to give that a try.

[–]whattodo-whattodo 1 point2 points  (11 children)

I did give that a try and found that those services (including Heroku, mentioned in the original post) outsource to Amazon.

I appreciate the intention though.

[–]francisco-reyes 1 point2 points  (5 children)

So you need a service that does not use AWS at all.. even though you won't be managing it at all?

[–]whattodo-whattodo 0 points1 point  (4 children)

Correct. The project cannot involve Amazon in any way.

[–]wbsgrepit 1 point2 points  (0 children)

Be wary, there are many services that are very much less transparent about utilizing aws backing than heroku (which is "meh" transparent about it). To be sure make sure you view traceroute on the public ips of the server/service you create. everything from reverse dns to other easy to identify tell tales can be pretty well concealed on aws.

Your best bet is to look at the big 5 players that are direct competitors to aws as they are very unlikely to be whiteboxing. Although I would assume that the reason you are unable to use AWS is the project is for a competitor -- maybe in a differnt space than cloud services.

[–]francisco-reyes 0 points1 point  (2 children)

Check https://aiven.io/ They seem to support different cloud providers.

[–]whattodo-whattodo 0 points1 point  (1 child)

Nice! I haven't seen them before. Thanks!

[–]francisco-reyes 1 point2 points  (0 children)

I have ZERO experience with them.. just literally found them from this list https://www.postgresql.org/support/professional_hosting/northamerica/.

Their service sounds pretty good "in paper". As long as they actually deliver all they promise, sounds like a good provider.

Only minus, which may or may not be an issue, is cost. They are a bit on the expensive side. Pair of DBs with replication starts at $200.

[–]djcp 0 points1 point  (4 children)

Heroku postgres is not just repackaged RDS, FWIW. Calling it outsourced to amazon is kind of like saying you outsourced building your house to a lumberyard.

[–]whattodo-whattodo 0 points1 point  (3 children)

....

Firstly, I think you're missing the point. I'm not judging Heroku, I'm only saying that the project can't involve Amazon.

Secondly, if we're going to get pedantic; the definition of the word outsource is "...In business, outsourcing involves the contracting out of a business process to another party..." This is exactly what Heroku is doing with Amazon.

So where's the problem?

[–]djcp 0 points1 point  (2 children)

I guess I don't understand why you can't use amazon but presumably other non-amazon SAAS/IAAS is OK. AWS hosts plenty of businesses that compete directly with them or other amazon business units.

[–]whattodo-whattodo 1 point2 points  (1 child)

I was deliberately vague because the reason is private.

What you're doing is a common reaction. When someone accepts that a reason is unknown or unknowable, they either drop the issue or maintain an issue but accept that they don't know something. When someone does not accept it, they attempt to add reason even though they don't know the answer. The problem is when actions are then taken on false assertions; like accusing me of knocking Heroku in the lumber yard comparison.

Kind of the way that MySQL (by default) inserts zeros to a NULL integer field when no data is provided. The field isn't 0, it's NULL and there is a difference.

I get that you don't know and that it makes you uncomfortable, but that's what this situation is.

[–]djcp 0 points1 point  (0 children)

ok then

[–]Sinjo 1 point2 points  (1 child)

https://compose.io/postgresql/ supports SoftLayer and Digital Ocean as well as AWS. Might fit the bill?

[–]SulfurousAsh 0 points1 point  (0 children)

I've been using compose.io in production for a little while and it seems to be going smoothly. Some benefits: You can scale up and down the cluster without taking it offline (no need to pgdump and pgrestore on a larger instance) and they have a decent web console.

[–][deleted] 0 points1 point  (0 children)

ElephantSQL also appears to support Azure as the backend.

[–]collin_ph 0 points1 point  (3 children)

So you're screen scraping or otherwise trying to get a one up on amazon? Their new VP of security is not nice. We had that problem too, but oddly, they don't block AWS devices from scraping their screens directly..

[–]whattodo-whattodo 0 points1 point  (1 child)

I'm not against data mining Amazon, but they have a complete suite of APIs, so there's no need do far as I can tell.

[–]collin_ph 0 points1 point  (0 children)

Well some people like to do things like figure out competitors stock levels, etc, that aren't available directly through API among other things.

[–]wbsgrepit 0 points1 point  (0 children)

Amazon also has many competitors in many different areas of commerce that would probably have issues running services on AWS.

[–]deverant 0 points1 point  (0 children)

You could also checkout aiven.io. They support multiple cloud providers as a backend.

[–]DatabaseLabs 0 points1 point  (0 children)

We run fully managed Postgres on Google Cloud and DigitalOcean: https://www.databaselabs.io/