Looking for a managed Postgres hosting provider
Managed Postgres database or self hosted
Best PostgreSQL provider
At what point should i switch to a managed service ?
What is PostgreSQL®?
PostgreSQL® touts itself as the world’s most advanced open source relational database, trusted to safely serve and scale even the most complicated data workloads. With more than 35 years of development, PostgreSQL is known for:
- Reliability: From write-ahead logging (WAL) and point-in-time recovery (PITR), to active standbys and multiple replication options, PostgreSQL® delivers the reliability that today’s applications demand.
- Performance: A long list of performance features ensures your database is responsive to the needs of your apps and users.
- Feature maturity: PostgreSQL® features — including those for security, internationalization, data types, and data integrity — have passed the tests of time.
Can I use PostgreSQL extensions with Heroku Postgres?
Yes, Heroku Postgres supports a wide variety of PostgreSQL extensions, including PostGIS for geospatial data, pg_stat_statements for performance monitoring, pgcrypto for hashing and encryption, and pgvector for AI/ML vector search capabilities.
You can enable most of these extensions directly on your database using the standard CREATE EXTENSION command. To learn more about how to install, manage, upgrade, and remove extensions, please see our documentation in the Heroku Dev Center.
What is Aiven for PostgreSQL®?
Aiven for PostgreSQL® is a managed version of the open source (released under the PostgreSQL license) PostgreSQL object relational database system. Aiven handles the operational overhead of running PostgreSQL, allowing you to focus on building your application, rather than on database administration and operation.
Videos
I currently run a small Postgres database (around 300MB) locally on my server, 30 iops/ 10 conns on average. It’s used as a supporting service next to my main ERP database, which is also running locally. Nothing too performance-critical — it’s only for internal use.
I’m based in the Netherlands and I’d like to move this Postgres DB to a hosted, managed provider, mainly so I don’t have to worry about backups, updates, or uptime. I’m open to paying for quality — doesn’t have to be the cheapest. S3 backups, monitoring, good EU-based infrastructure would all be a bonus.
Requirements: Managed PostgreSQL (I don’t want to self-host on a VPS) EU datacenter (NL/DE preferred)
So far I’ve looked at: Scaleway (seems solid, but not sure about support quality) Aiven (looks great but might be overkill for this small DB?) Clever cloud( seems good for me)
Any recommendations from people hosting small/medium Postgres DBs in the EU?