Aiven for PostgreSQL Reviews & Product Details - Page 7

Getting Postgresql for production just need few clicks on console.aiven.io Review collected by and hosted on G2.com.

I think Aiven can improve the monitoring tools for postgresql like pg-dash Review collected by and hosted on G2.com.

Aiven PostgreSQL provides reliable managed database service and highly flexible to scale up or down.

The interface is easy to use and intuitive, well done! Review collected by and hosted on G2.com.

It's more expensive than managing your own servers but it's totally worth it. Review collected by and hosted on G2.com.

The interface is simple but they seem to have thought of everything.

All the info you need to connect, which is what you primarily need to for a DB in the cloud, is provided simply and in a super obvious manner! Review collected by and hosted on G2.com.

They do not have a function to dump a database image, be it mysqldump or pg_dump. Review collected by and hosted on G2.com.

- you can choose cloud provider/region

- you have minimal monitoring

- also can connect something like Prometheus for better statistics Review collected by and hosted on G2.com.

- a quite hight price

- we want root permission for postgres

- we need something like autoscale by load or scheduler Review collected by and hosted on G2.com.

- Fully managed: saves us huge amount of time in maintenance

- Fair pricing

- Attentive support

- Simplicity of usage

- New versions support, features, regions support (both in Amazon & GCP) Review collected by and hosted on G2.com.

- Any export / integrations of logs outside of Aiven are quite hard to use / limited / introduce difficulties troubleshooting

- It would be lovely to have better granularity in the history and zooming-in/-out for the metrics graphs of the different services

- It would be great to have a failover/backups feature cross-regions Review collected by and hosted on G2.com.

Simplicity to build services and database on your platform Review collected by and hosted on G2.com.

There is not a tutorial on how to connect to your database with pgAdmin and i have trouble to connect directly to my databases Review collected by and hosted on G2.com.

Modern Software:

- Latest version of PostgreSQL database engine available (11.2). Our previous hosted database provider was stuck at version 9.6.

Features:

- Quick and easy database forking.

- Painless Google Cloud Platform VPC peering setup at no extra cost.

- Easy to switch back-and-forth between VPC and public network.

- Direct access to the secondary read-only replica on high availability plans. Other providers usually hide the replica and only make it available when failing over.

Management and Monitoring:

- Good web management console.

- Command-line interface client.

- Terraform infrastructure management. I haven't tested it yet, but I plan to.

- Integration with Datadog infrastructure monitoring service provider.

Security:

- TOTP two-factor authentication.

Support:

- Good email support. I asked some technical questions before I started using the service and the response was fast and detailed. Review collected by and hosted on G2.com.

Pricing and Plans:

- More expensive than AWS RDS and GCP Cloud SQL. However, smaller providers like Aiven take their database offerings more seriously instead of just seeing them as add-ons to their other cloud services.

- Storage options are too inflexible. They start with 8 GB and then immediately jump to 80 GB.

Features:

- Backup downloading is cumbersome. You must use PostgreSQL's pgdump CLI utility, and if you want to download an older snapshot, you must first restore it to a database instance using point-in-time recovery and then create a dump using pgdump. Ideally, I should be able to go to the web console, select a snapshot and click "Download".

- Backup retention time is too short. Business plans only have 14 days, while I think that 30 days should be the minimum for production-grade plans.

Security:

- The current plaintext database administrator password can be obtained from the web console. Access to the web console itself can be protected with two-factor authentication, but I still think that the best password recovery option is the generation of a new password. Review collected by and hosted on G2.com.

I love the flexibility of the hosting cloud providers Aiven offers. Their integrations are the primary reason I initially looked into them. Review collected by and hosted on G2.com.

Price, but you do get what you pay for so it's a toss up.

I didn't understand the "100% Availability guarantee" advertised only means you wont lose your data, and Aiven will auto-failover, but during the auto fail-over time the database will be unavailable. That caused pain early in my experience, I almost immediately upgraded to a business plan to get a live follower, but I would have preferred to understand the impact and be able to make that decision BEFORE my data being inaccessible for the rebuild time. Review collected by and hosted on G2.com.

I can upgrade the service plan of a database quickly and easily with no downtime. Also the point-in-time backup gives a lot of reassurance. Review collected by and hosted on G2.com.

Limited role and permissions management features for administrators, but nothing we couldn't work around easily and I think more granularity is in the roadmap. Review collected by and hosted on G2.com.

Super simple usage of VPC peering, PGBouncer coupled with amazing performance for a cloud based database. Really encouraged so far. Review collected by and hosted on G2.com.

The UI on the pools page could be a little crisper, and more configuration options about the db pools would be great - e.g. per user connection limits rather than just per-db Review collected by and hosted on G2.com.