Looking for a managed Postgres hosting provider
At what point should i switch to a managed service ?
Managed Postgres database or self hosted
Best PostgreSQL provider
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.
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?
I ve been using sqlite 4ever with my projects, but how a client wants me to create an e-commerce platform and the stack i chose, heavily recimmends using a postgres db, i already had one on a vps which i use for my selhosted apps, it s been working fine but i have next to no knowledge about maintaining a db. Obviously for production purposes i would prefer to have a production level quality, but on the other hand, the app isn't massive enough to make me consider a managed service, and the offerings i checked so far all feel ... "Subpart" especially when it comes to storage space, ant they get expensive real quick. I m conflicted about whether it will be worth it spend so much money out of the box or if i can get away with selfhosting it (at least untill the app grows eniugh). What do u think ? And what managed platforms do u recommend for postgres ?