PostgreSQL 16
PostgreSQL 16 on every plan, shared and dedicated.
What is managed PostgreSQL hosting?
Managed PostgreSQL hosting means the provider runs the Postgres server for you. You get a database endpoint, backups and failover. You do not patch the server, set up replication or manage the disks.
Hostim runs PostgreSQL 16 in Germany. Every server has a primary and a hot standby kept in sync by streaming replication. If the primary fails, the standby is promoted and the endpoint follows it. This is included on every plan, including the free 256 MB plan. Daily backups are encrypted, kept 7 days and stored in Germany.
Your app runs on the same platform as the database. The connection details are injected as environment variables, and the database is not reachable from the public internet.
What you get
The same managed setup on every plan, from the free 256 MB database to the dedicated 100 GB server.
Failover on every plan
Primary plus hot standby with streaming replication and automatic failover. No extra tier for high availability.
Daily backups, 7 days
Encrypted daily backups, kept for 7 days and stored in Germany. Download them from the console or with hostim backups download.
pgvector, PostGIS and more
Turn on vector, postgis, pg_trgm, citext or unaccent per database, in the console or with hostim db postgres extensions add.
Private networking and env vars
Apps in the same project connect over private networking. For a database named blog, BLOG_POSTGRES_HOST, BLOG_POSTGRES_PORT, BLOG_POSTGRES_DATABASE, BLOG_POSTGRES_USER and BLOG_POSTGRES_PASSWORD are injected automatically.
SSH bastion for clients and dumps
Run pg_dump or connect DBeaver, pgAdmin or TablePlus through an SSH bastion tunnel. Load a plain-SQL dump with hostim db postgres import.
PostgreSQL plans and prices
Shared plans are an isolated database on a shared server. Dedicated plans run on their own server. Prices in EUR per month. You can scale a plan up or down later.
| Plan | Type | Storage | CPU | RAM | Price |
|---|---|---|---|---|---|
| sp-0 | Shared | 256 MB | Shared | Shared | €0 |
| sp-1 | Shared | 1 GB | Shared | Shared | €1 |
| sp-5 | Shared | 5 GB | Shared | Shared | €5 |
| sp-10 | Shared | 10 GB | Shared | Shared | €10 |
| sp-15 | Shared | 15 GB | Shared | Shared | €15 |
| drp-25 | Dedicated | 25 GB | 1 vCPU | 2 GB | €25 |
| drp-50 | Dedicated | 50 GB | 2 vCPU | 4 GB | €50 |
| drp-75 | Dedicated | 75 GB | 3 vCPU | 6 GB | €75 |
| drp-100 | Dedicated | 100 GB | 4 vCPU | 8 GB | €100 |
Full plan details and checkout are on the pricing page. Only need a free database? See free PostgreSQL hosting for how the free tier compares.
How to choose a PostgreSQL host
Most Postgres hosts look the same on a feature list. These questions separate them:
- Is failover included, or a paid tier? A single-node database is down until the node comes back. Many providers charge extra for a standby.
- Where do the database and the backups live? For EU data, check both. Backups are often stored in a different region from the database.
- Does the database sleep? Serverless Postgres scales to zero and adds a cold start to the first query. An always-on server does not.
- Which extensions can you turn on? pgvector for embeddings and PostGIS for maps are the usual ones to check.
- Where does the app run? If the app runs on another platform, every query crosses the public internet. Running both on one platform keeps the traffic private and puts both on one bill.
Comparing with Postgres platforms? See Neon alternative, Supabase alternative and Supabase vs Postgres.
What Hostim PostgreSQL does not do
- No public endpoint. Apps in the same project connect privately; your laptop connects through the SSH bastion.
- No point-in-time restore. You restore from a daily backup, not to a chosen second.
- No self-service restore yet. Download a backup and load it yourself, or ask support.
- A short list of extensions. Extensions that run arbitrary code or need server-wide settings, such as TimescaleDB or plpython3u, are not available.
- The TLS certificate is self-signed. Use sslmode=require, or sslmode=no-verify with the Node.js pg driver.
- One region: Germany.
- No read replicas exposed to you.
PostgreSQL hosting FAQ
What PostgreSQL version does Hostim run?
PostgreSQL 16 on every plan.
Is PostgreSQL on Hostim highly available?
Yes. Every server runs a primary and a hot standby with streaming replication. If the primary fails, the standby is promoted automatically. This is included on every plan, including the free one.
Can I use pgvector or PostGIS?
Yes. You can turn on vector (pgvector), postgis, pg_trgm, citext and unaccent per database, in the console or with hostim db postgres extensions add <database> <extension>.
How do I connect from my laptop?
The database has no public endpoint. Open an SSH tunnel through the Hostim bastion, then point psql, DBeaver, pgAdmin or TablePlus at the local end of the tunnel. The bastion guide has the exact steps.
How do I move an existing Postgres database to Hostim?
Run pg_dump --format=plain against your old server, turn on any extensions you use, then run hostim db postgres import <database> -f dump.sql. The CLI streams the dump through the SSH bastion into psql.
Where is my data stored?
The database runs in Germany, and daily backups are stored encrypted in Germany. You can download backups from the console or with hostim backups download.
Is there a free plan?
Yes. The sp-0 plan has 256 MB of storage, the same failover and backups as paid plans, and needs no card to start. It does not sleep.
Start now
Put something live today.
Open the dashboard and deploy a Docker image, a Git repo or a template. The 5-day trial project needs no card.