Introducing G2.ai, the future of software buying.Try now
Aiven for PostgreSQL
Save to My Lists
Claimed
Claimed

Aiven for PostgreSQL Pros and Cons: Top Advantages and Disadvantages

Quick AI Summary Based on G2 Reviews

Generated from real user reviews

Users value the hands-off high availability of Aiven for PostgreSQL, ensuring reliability and effective disaster recovery. (1 mentions)
Users value the automated backup system of Aiven for PostgreSQL, enhancing their disaster recovery capabilities reliably. (1 mentions)
Users laud the automated backup system of Aiven for PostgreSQL, emphasizing its reliability for disaster recovery. (1 mentions)
Users value the automated data recovery in Aiven for PostgreSQL, ensuring reliable and hands-off disaster management. (1 mentions)
Users value the automated high availability of Aiven for PostgreSQL, appreciating its reliability and ease of use. (1 mentions)
Users find Aiven for PostgreSQL notably expensive, particularly due to the significant management layer premium. (1 mentions)
Users find Aiven for PostgreSQL's expensive licensing a drawback, citing high costs for the management layer. (1 mentions)

Top Rated Aiven for PostgreSQL Alternatives

Google Cloud SQL
(354)
4.5 out of 5

86 Aiven for PostgreSQL Reviews

4.4 out of 5
The next elements are filters and will change the displayed results once they are selected.
Search reviews
Hide FiltersMore Filters
The next elements are filters and will change the displayed results once they are selected.
The next elements are filters and will change the displayed results once they are selected.
86 Aiven for PostgreSQL Reviews
4.4 out of 5
86 Aiven for PostgreSQL Reviews
4.4 out of 5

Aiven for PostgreSQL Pros and Cons

How are these determined?Information
Pros and Cons are compiled from review feedback and grouped into themes to provide an easy-to-understand summary of user reviews.
Pros
Cons
G2 reviews are authentic and verified.
Xavier P.
XP
Infrastructure Engineer
Small-Business (50 or fewer emp.)
"We are using timescale with IaC and it was awesome!"
What do you like best about Aiven for PostgreSQL?

the IaC works phenomenal, well done team! Review collected by and hosted on G2.com.

What do you dislike about Aiven for PostgreSQL?

it would be awesome if I can create users on PG using IaC Review collected by and hosted on G2.com.

Rifki H.
RH
DevOps Engineer
Mid-Market (51-1000 emp.)
"Easy to Custom spec and upgrade spec"
What do you like best about Aiven for PostgreSQL?

Easy to replicate more database, so from apps can balancing the load query Review collected by and hosted on G2.com.

What do you dislike about Aiven for PostgreSQL?

difficult to custom disk size, because we need just extra disk size sometimes. Review collected by and hosted on G2.com.

Response from Tuomas Lounamaa of Aiven for PostgreSQL

Hi Rifki, thank you for the feedback. We launched dynamic disk sizing in December 2021 for our PostgreSQL service. Please read more here: https://aiven.io/blog/announcing-dynamic-disk-sizing

Verified User in Financial Services
AF
Small-Business (50 or fewer emp.)
"Value-add service for offloading Postgres management, with improvement opportunities"
What do you like best about Aiven for PostgreSQL?

The service is simple and easy to use. It is easy to spin up a Postgres instance in Aiven's cloud service via the UI or infrastructure-as-code tooling (such as Terraform) and have this operate alongside our existing cloud infrastructure in a private VPC with no shared access to the internet.

The functionality for enterprise usage of the services has improved markedly in recent months, with facilities for shared group control of an account and centralised billing accounts, just like the big three cloud providers. I have confidence that my data is hosted in a secure facility by a team of experts who understand deeply the systems they are integrated with. The console also surprises me with features I didn't know existed; today I found out Aiven is ahead of the curve by offering SAML authentication as standard. Way to go for not requiring an "enterprise" pricing plan for such essential functionality!

Running services via Aiven is by no means the cheapest option when considering the raw hardware/cloud instance costs, but after taking into account the operational and opportunity costs of running our own database services, it's competitive. Review collected by and hosted on G2.com.

What do you dislike about Aiven for PostgreSQL?

There are areas for Aiven to improve around data residency/governance and the feeling I get regarding the safety of my data when using Aiven's services. I would also like to see developments in Aiven's technical approach to managing the services to instil more confidence that this service will adequately safeguard my data.

1. Currently, Aiven services are hosted inside Aiven's cloud provider account, not a cloud account of my own. I do not however understand how our data are safeguarded in the event Aiven were to cease trading or a compromised actor inside Aiven were to gain access to and/or manipulate our data. While Aiven has appropriate audited ISO and SoC attestations, such process-based controls are not the same as hard limits on the ability for a bad actor to move laterally in the event they maliciously gained access as a privileged user to your cloud account. This gives me residual concern regarding the use of Aiven's services and consideration regarding protecting the data by making my own backups outside Aiven.

2. I would like the ability to "bring your own cloud" as standard, for all of Aiven's services. This would take the form of sharing access via a cloud provider's native IAM credentials to a project and binding the appropriate IAM permissions to enable Aiven to spin up and manage its own instances in the project. While this is a function available once usage crosses a higher monthly commit with Aiven, Postgres is actually really efficient and so it will take a long time for even a widely-used, highly-scaled service to reach this threshold.

Offering a bring your own cloud service as standard would resolve many of the concerns around point #1 regarding data ownership, because I would have assurance that my data are stored in cloud infrastructure attached to my own billing account. This reassurance is essential in all cases, but especially so in regulated industries.

As a product feature, Aiven could subsequently offer "cloud-provider security protection" by having its managed services offer to make a backup from the user's production instances in their own cloud into storage buckets in Aiven's cloud accounts (held under Aiven's separate billing). This would offer customers peace of mind that their data are safely streamed out to another organisation's cloud account and thus there is redundancy in the event their own cloud account should be accidentally compromised or lost for some reason.

Furthermore, Aiven should provide direct access to the write-ahead logs.

3. Further to data backups, there is very minimal insight into the controls Aiven has in place around these. Aiven has great backup functionality including point-in-time restores, but to have confidence that they are usable, I need to know they are resilient to various erroneous (even byzantine) conditions in which a user might need to resort to them. Once again, process-based controls are useful for managing risk, but there is always a residual risk which cannot be discharged in Aiven hosting large quantities of user data and thus being a singularly unique target to attack with potentially widespread ramifications for more than just Aiven's own business.

4. Aiven's topology for Google Cloud Platform appears to place all instances and VPCs into a single project on Aiven's side. Is this scalable? How are risks handled here?

5. The console has a number of bugs which introduce operational hazards. For example, the bug when attempting to activate a project in the project selector which the user can see (it is part of a centralised account) but for which permissions have not propagated, thus they do not have permission to inspect inside the project. Rather than present an appropriate "Permission denied" error which interrupts the user's workflow, the project selector will instead silently jump to the next project which the user does have permissions to access. This is very dangerous because it means a user who believed they were accessing a development project, perhaps to remove some infrastructure, can be connected instead to a production project and inadvertently delete the wrong instance! Good operational practices in verifying the project prior to destructive operations are good here, but such bugs do not instil confidence as to other bugs which may exist in the console. I have reported this to product support so I hope it can be rectified soon.

6. Aiven's support staff are great! You should definitely reach out to them. However, it's not clear what the SLA around support is, or how I might upgrade this if I needed a tighter SLA on the services I take from them. Review collected by and hosted on G2.com.

Hafidz B.
HB
Devops Engineer
Mid-Market (51-1000 emp.)
"PostgreSQL in Aiven, Best Database Managed Service"
What do you like best about Aiven for PostgreSQL?

I really like the database setup, very well configured. PostgreSQL in Aiven also have regular maintenance service like. Review collected by and hosted on G2.com.

What do you dislike about Aiven for PostgreSQL?

I cannot apply some custom configuration. Review collected by and hosted on G2.com.

Verified User in Computer Software
AC
Mid-Market (51-1000 emp.)
"Fantastic DB as a service"
What do you like best about Aiven for PostgreSQL?

Hosting and scaling massive databases can be challenging, Aiven makes it look easy and efforless Review collected by and hosted on G2.com.

What do you dislike about Aiven for PostgreSQL?

I've had a fantastic experience so it's hard to say Review collected by and hosted on G2.com.

Ahmad F.
AF
Junior Devops
Mid-Market (51-1000 emp.)
"High Available Traffic for Customer"
What do you like best about Aiven for PostgreSQL?

with aiven, scalability and upgrade process can be done fast, efficiently in brief steps Review collected by and hosted on G2.com.

What do you dislike about Aiven for PostgreSQL?

it seldom takes the service long enough downtime when there's a maintenance Review collected by and hosted on G2.com.

Jukka L.
JL
Chairman of the board
Small-Business (50 or fewer emp.)
"Easy to set up"
What do you like best about Aiven for PostgreSQL?

Aiven was extremely easy to set-up and the support has been so far been great. The free trial was also nicely set up. Review collected by and hosted on G2.com.

What do you dislike about Aiven for PostgreSQL?

The tiers could be structured in more flexible manner for very specific use cases Review collected by and hosted on G2.com.

Verified User in Online Media
AO
Mid-Market (51-1000 emp.)
"we take out the burnout outside, so we can focus on our business"
What do you like best about Aiven for PostgreSQL?

HA, metric, logging, backup, db pool, vpc peering, read replica Review collected by and hosted on G2.com.

What do you dislike about Aiven for PostgreSQL?

can't transfer a service into different project Review collected by and hosted on G2.com.

Response from Tuomas Lounamaa of Aiven for PostgreSQL

Thank you for your feedback. I believe we have launched what you are looking for with our cross project fork. Please read more here: https://help.aiven.io/en/articles/5040495-cross-project-fork

Adam R.
AR
Small-Business (50 or fewer emp.)
"Difficult to integrate with infrastructure as code"
What do you like best about Aiven for PostgreSQL?

Everything that we deploy works flawlessly so far, but our deployment of choice is terraform and Aiven's terraform provider is quite immature, and poorly documented. This causes problems for us which Aiven have done good work to address some of, but still have some way to go

I like that it has write ahead logging, which cloudSQL doesn't have for cloudSQL postgres, Aiven are more up to date in this regard. Review collected by and hosted on G2.com.

What do you dislike about Aiven for PostgreSQL?

your terraform documentation! plus your provider doesn't/didn't work as terraform providers should, violating basic assumptions of the terraform framework and causing me weeks of work when it should have been hours. The software felt untested, and this caused us a couple of weeks to sort out (which, to Aiven's credit, we did sort out)

Please see a list of terraform providers that manage to keep up to date enough that they can submit their documentation to the official terraform website https://www.terraform.io/docs/providers/index.html (that's 133 providers). IMO this is an absolute minimum if you're going to be releasing a terraform provider for an expensive paid for product.

This has totally coloured my view of Aiven because your service seems to be working flawlessly and it seems to have unjustly turned me off what seems to be an otherwise excellent product. Logging into the console is a genuinely pleasant experience but it is not a solution to a problem inside terraform - If it's not in terraform it makes it very difficult to interface with our automation.

Additionally, your Aiven_project_service resource is totally overloaded, I get that they probably share a parent object but I think they should be separate resources, When I'm configuring Postgres I don't want to also have to wade through the documentation on elastic cloud, kafka etc as well, this is compounded by the already lacking documentation, which forced me to manually inspect attributes of resources on runs.

Please forget the CEO's/CTO's you're showing your web console, and instead consider the people that will actually be using your software. The business (hopefully) doesn't run because they have sys admins clicking through a UI!

I'm sure your infra is as (declarative) code, there's of course very good reason for it; I want mine to be as well. Review collected by and hosted on G2.com.

Verified User in Apparel & Fashion
AA
Small-Business (50 or fewer emp.)
"Everything works just great!"
What do you like best about Aiven for PostgreSQL?

Web UI is really easy to use, and connections to instance are easy to setup. Review collected by and hosted on G2.com.

What do you dislike about Aiven for PostgreSQL?

If you could setup roles and access for user directly in Aiven UI that would be great. Review collected by and hosted on G2.com.

Aiven for PostgreSQL Comparisons
Product Avatar Image
Cloud SQL
Compare Now
Product Avatar Image
Snowflake
Compare Now
Product Avatar Image
Amazon Relational Database Service (RDS)
Compare Now
Aiven for PostgreSQL Features
Storage
Availability
Stability
Aiven for PostgreSQL