Aiven PostgreSQL Reviews
by Aiven4.7 / 5 52 reviews
Reviewed on 02/10/2019
An excellent, full-featured database provider
The general ease of operation for:
- Spinning up new databases
- Scaling up
- Scaling down
- Migrating to a different region
- Restoring backups
Is really great. It's amazing how many features you get out of the box.
The plans with redundancy are also cool because you get full access to the slave as a read-only replica, this means you can run heavy select queries without putting load on the main database.
There is a very significant "it just works" factor to it, which is not something I would imagine myself saying about a database provider so easily.
They are not the cheapest
Monitoring/alerting options were a bit lackluste, but this has improved recently.
Reviewed on 25/10/2017
Aiven is very efficent for me, because is very easy use to
the serves restores in atumatic in downtime
the backup automatic
facility to see the performance
graph of metrics
easy admin of users
the autimatic backups and restores
the upgrades of service plans is a very easy and autimatic
the agents of service desk are very efficent and friendly
can't watch logs of befores days
aiven dont have a panel to execute querys, i could execute querys without any administrator of postgresql from your platform
cant admin sessions, i could close to sessions without pgadmin
by Aiven on 20/02/2019
Thank you for your review. We¿re glad to hear you have enjoyed the ease of use of our managed PostgreSQL.
First, I wanted to let you know that it is now possible to close connections directly from console.
Second, our logs view has been improved; for longer logs retention, we support integration to Elasticsearch, where you can keep logs for unlimited (limited by amount of disk space) time.
Reviewed on 16/10/2017
Excellent, well-designed product. Hard to imagine an easier solution to this problem.
Pros: The best feature is how easy it is to get up and running. Once you've set up an instance, you literally (in our case) just had to copy-and-paste the database URL into our site's (Django-based) configuration. The fact that scaling the instances is so easy also makes it quite comfortable to just start with a small one and then upgrade it as your needs increase.
Cons: We had one or two cases where the instance was unreachable, even though the dashboard reported that it was up. Considering the price, this is pretty good for over a year of service with no redundancy, though. Also, automatically upgrading the PostgreSQL version is obviously a double-edged sword. An opt-out feature might be helpful. We once started getting some errors when the postgres-server version changed.
Reviewed on 01/04/2019
Aiven is the perfect, no-lock-in DB solution
Pros: Aiven makes it trival to move databases between cloud providers. The stickiest thing about any hyperscaler (AWS/Google/Azure) is your data - it's a PAIN to move. Aiven makes changing your cloud provider a literal point and shoot operation, something that could take weeks of planning trying to from RDS to Cloud SQL or the like.
Cons: A little more customization in the pricing would be nice (and the ability to run within a VPC instead of having to peer VPCs), but honestly there's very little I don't like about Aiven.
Reviewed on 22/07/2019
Remote replicas to the rescue!
Comments: We tested and we loved it, the remote replica is a service that takes weight out of our shoulders in a brilliant and simple way.
Pros: The interface is easy to use and intuitive. The remote replica option is saving the company time. In the past, it was hard to manage and configure the remote replicas using tools like Bucardo and PostgreSQL in RDS, which does not support binary replication (at least it didn't back then). The replicas between the remote databases happen almost instantly. Great support for extensions.
Cons: The chat support takes a long time to answer the questions but when they do, the answers are to the point and helpful.
Reviewed on 24/10/2019
Best managed DB so far
Comments: After we started using Aiven, DB's have been one thing that we don't have to worry about.
Pros: It was just super simple to start using it. The possibility to deploy the service to the same locations where we host our capacity was crucial for us. Also as a nice plus, aiven has made their own Terraform provider which we also use to manage our capacity.
Cons: Option to create "Service Accounts" would be really nice. Currently all the API tokens are tied to actual user accounts and that might cause problems at some point. But other than that there's not much not to like :)
Reviewed on 13/10/2017
Using Aiven has been a great experience because it has permitted us to deploy faster database server
Comments: Deploying database servers it is now really fast for us.
Pros: I like that is possible to deploy PostgreSQL within seconds. I also really like that is possible to upgrade to a minor or major version of PostgreSQL without a noticeable downtime. I like the offering of HA services. I like the great customer support.
Cons: That it is not possible to have customizable PostgreSQL logs. On our dedicated servers we customize this logs to show us querys that last longer than 5 seconds, currently this is not possible with Aiven.
Reviewed on 07/04/2019
Focus on the productive stuff
Comments: Extremely esay to use and get started with in seconds. Very helpful support if so be needed and a very reliable service.
Pros: It's incredibly easy to spin up a postgreSQL instance and start being productive. Everything from creating a secure password to SSL-certificates are handled automatically. Point in time backups make you confident to use and test without gambling hours of work and for the serious tests and development environments - spin up a replica by forking the database with the press of a button!
Cons: It is a bit expensive if you need more disk space, which isn't unusual when dealing with data and databases.
Reviewed on 18/10/2017
It's great. Everything just works; setup was effortless; customer service is responsive and helpful.
Pros: The best thing are the no-downtime migrations and upgrades. The setup was quick and easy and since then no maintenance has been required. Customer service is great and pro-active. The dashboard works well.
Cons: As far as I can tell there's no way to set a separate billing email. It would be nice to also see in the dashboard what's taking up most memory and disk space and to be able to set up alerts, such as if there are queries that take too long to execute.
by Aiven on 20/02/2019
Thanks for the review! Great to hear you have had a good experience so far.
Regarding to your comment on setting a separate billing email, field for that has now been made available.
Reviewed on 22/07/2019
Aiven PostgreSQL review
Pros: Performance is much higher than Amazon RDS
Cons: Failover can take quite a long time.
Reviewed on 16/10/2019
Easy to use console and high availability
Pros: The console was easy to use and intuitive. We were evaluating GCP CloudSQL vs Aiven and really what it came down to is that Aiven has better up time. CloudSQL has maintenance periods of 5-10 minutes that render the service unavailable, which is unacceptable for our uses. We also liked that Aiven could host on any major cloud platform (on GCP in our case).
Cons: At first it wasn't clear to me at first that I needed to connect to the DB and create users and manage the permissions manually through the CLI. Might be nice to have an initial user creation or way to manage the db users in the console.
Reviewed on 14/03/2019
Overall is more far better than Google cloudsql
Comments: Good so far, you guys provide mysql as well?
Pros: Availability and live migration feature is awesome
Cons: Last time (couple weeks) it still cannot zoom to specific range of time in metric dashboard or i am wrong remember
Reviewed on 26/01/2018
Works well, has cloud datacenters in many regions.
Comments: Don't have to host Linux servers for it myself.
Pros: Datacenters in multiple regions, multiple PostgreSQL versions. General high level of availability. Support is helpful and pretty fast (located in my timezone.)
Cons: No real cons actually. Had a problem once (which was related to my PG driver etc), the customer support helped me resolve it fairly quickly.
Reviewed on 01/09/2018
So simple and powerfull
Comments: I am very satisfied with Aiven so far.It eliminated the need for in-house solutions for backup, scaling and upgrading a PostgreSQL server.
Pros: I have only used the PostgreSQL service so far and I really like how easy it is to start, fork en upgrade the service. A great feature, and a must for us, is that you can choose on which cloud provider and location the service should be deployed. We have been hosting our own PostgreSQL server for years and had to manage upgrades, backup and scaling on our own. And it feels great to finally leave that behind us and start using PostgreSQL as a service. The support is great to. I have been in contact with the support using the chat feature and have been helped every time.
Cons: The official API client was a bit hard to understand at first.
Reviewed on 13/10/2017
Overall good, customer support is good, however pricing is not great compared to AWS, logs not good.
Pros: Ease of use, being able to upgrade, downgrade hardware as needed, great customer support, overall decent interface.
Cons: Hardware versus price is not great, especially compared to AWS, not great logging, seems difficult to customize, no auto scaling.
Reviewed on 07/08/2018
new to cloud db services
Comments: Very happy with service and support
- Australian data centre (no one has these!)
- Postgres support
- Easy to create an account and a database
- Customer support is very good
- Documentation and guides are very good
- Intergration with Datadog was easy
1. The default db is named 'defaultdb' so i created new dbs for staging/prod so i dont use the default db, i find this a bit confusing
2. On overview page only default db is shown, I would prefer to see all my db's and possibly set favourites
3. When I hit the server the Current Queries tab shows IP address but duration and db fields are blank?
4. Pricing seems a little steep for mid level single app users
5. Would like to see explanations in console graphs to better understand what they mean
Reviewed on 22/02/2018
It works nicely
Easy and fast to start a new service.
Easy service overview.
Nice pricerange from hobby to business
Cons: We had a service issue some time ago where we had no database for 4 hours. We needed to upgrade to business to have better fallback
Reviewed on 14/10/2017
Nice UI. Great support. Great features (for PG, a bit less for redis unfortunately)
Pros: Setup is very intuitive, and it seems to work great. Support was prompt and knowledgeable (which is hugely important). PG features seem solid and the flexibility to choose the cloud hosting, size etc is great.
Cons: easy Redis backup/import is still missing unfortunately. We'd love to use Aiven for redis too, but with those limitations we can't yet. I'm still a bit hesitant about how likely Aiven is to stay in business as a company. It's not so well known and hard to know who's behind it and that it's doing well financially to keep going for many years. (btw, I think you guys should be more active on HackerNews and other geek channels where you should market yourselves.)
Reviewed on 14/03/2018
Comments: The implementation of our business!
Pros: Can't fault Aiven at all, great service, the exact services we require (postgres and elasticsearch) and always more than willing to help
Cons: While it is a managed service you do need to have at least a minimum of knowledge to setup and run the services on offer.
Reviewed on 31/10/2018
Pros: Easy to deploy and setup replication on any cloud provider we like
Cons: We want to move to our production environment but we need a SOC2. Currently, aiven does not have that. WHEN WILL YOU GET IT?!
by Aiven on 20/02/2019
Thanks for the review! We¿re glad your experience has been good so far.
Regarding your question, we are aiming for SOC2 report it during 2019. In case you have requested the feature through our support, you will be notified when it¿s available. Meanwhile, I suggest you following our RSS feeds for further updates.
To demonstrate our commitment to our customers' information security, we maintain compliance with all major data regulations and are ISO 27001 certified.
Thanks again and stay tuned!
Reviewed on 05/07/2019
Pros: The ability to link to our Google cloud cluster using VPC was very valuable. Features such as PITR and connection pooling makes Avien PostgreSQL in another league entirely when it comes to cloud services. Well done.
Cons: It would be useful to allow a whitelisted IP address into the service even when its configured with VPC
Reviewed on 02/01/2018
Good for quick start, but more features required
Ease of use, quick setup.
We easily migrated to cloud and don't have to manage PostgreSQL any more.
Cons: Not enough features and settings for PostgreSQL: for example: slow queries logs are missing and we have to monitor by third party tools.
Reviewed on 20/11/2017
Great PostgreSQL offering with managed PGBouncher
- Managed PGBouncher
- easy setup and upgrade
- quicky offering new technologies (e.g. PostgreSQL 10)
Cons: - lack of integration with datadog for metrics. right now we need to get some metrics manually using the Aiven metrics API
Reviewed on 08/07/2019
Great trial period experience
Comments: Using Aiven lets us keep our DB from the tight grip of the majors and avoid lockin.
Pros: Excellent "managed" db setup, overall. I liked how Aiven seemed to abstract the cloud-company-centric database offerings that each cloud co offers but made it appear "seamless" to me.
Cons: Could use a better explanation of pricing w.r.t. what the standard google/amzn/do db setup might cost.
Reviewed on 20/02/2019
Great affordable product
Comments: Overall, it's been a smooth experience transitioning and migrating over from our previous hosting platform. The support has been absolutely great thus far.
Pros: It's clean, simple-to-use, and best of all, is serviced by very knowledgeable IT staff who can answer the finer details of our technical questions and make nuanced recommendations. The pricing plan is also friendlier than those offered by the bigger platforms.
Cons: It would be great if we can be on the trial plan too, and getting on it was a bit of a hassle, but otherwise not much complaints.