Install ClickHouse on your VPS
Infraa installs ClickHouse (server and client) on your VPS from the official ClickHouse apt repository — no distro ships it. The repo publishes one distro-agnostic suite, so Ubuntu 22.04, 24.04, and Debian 12 all track upstream's latest stable release. Every listener binds to localhost out of the box, and one approval covers the repository, packages, and service.
- Versions
- Latest stable ClickHouse (26.x line), from the official ClickHouse apt repository
- Works on
- Ubuntu 22.04, Ubuntu 24.04, and Debian 12
- Package source
- Official ClickHouse repository
What does the ClickHouse install do?
- Adds the ClickHouse apt repository with its signing key — the key ships inside the module and is pinned at install time.
- Installs clickhouse-server and clickhouse-client via apt.
- Enables and starts the clickhouse-server systemd unit.
- Writes no configuration: the stock config listens on localhost only — HTTP on 8123, native protocol on 9000, MySQL/PostgreSQL wire-compat on 9004/9005.
How do I install ClickHouse with Infraa?
Connect your server
Run the Infraa install one-liner (curl install.infraa.sh | sh) on your VPS. The agent registers over an outbound connection in about 30 seconds — no inbound ports, no SSH keys to share.
Pick the service
Choose it from the one-click catalog in the dashboard, or just ask in chat. Infraa turns your request into a concrete, reviewable plan.
Review and approve
Read exactly what will run, then approve. The agent executes only the approved, cryptographically signed steps and streams progress live.
What happens after the install?
Infraa checks ClickHouse every 60 seconds — the clickhouse-server unit and the HTTP port. The unattended install leaves the built-in default user passwordless (contained by the loopback-only bind), so Infraa's standing recommendation is to set a password early. Users, memory limits, and replication are handled through chat.
ClickHouse on Infraa — common questions
01How big a server does ClickHouse need?
More than most modules: ClickHouse idles around 1 GB of RAM, upstream recommends 4 GB+ for real workloads, and the packages unpack to about 1 GB of disk. Don't co-locate it with a memory-hungry app on a small VPS — Infraa's resource checks flag this before the install.
02Is ClickHouse reachable from outside the server?
No. The stock config binds every listener to 127.0.0.1 — the HTTP interface (8123), the native protocol (9000), and the MySQL and PostgreSQL compatibility ports (9004/9005). Only local processes can connect.
03Does the ClickHouse default user have a password?
Not after an unattended install — the interactive password prompt the package normally shows is skipped. That's contained by the localhost-only bind, but any local process can read and write every database, so set a password early; Infraa proposes this as a standing recommendation.
Connect a server in 30 seconds, then install ClickHouse from the catalog or just ask in chat.
