Self-host CockroachDB on a VPS

A distributed SQL database that speaks the Postgres wire protocol, run as one insecure node for development and small workloads. The SQL port is private, the admin console is the web page. Source available license.

levelrail-cli templates deploy cockroachdb --name my-cockroachdb

Specification

Status
Listed
Category
Database Tools
Services
cockroachdb
Ports
8080, 26257
Volumes
1
Memory
about 1 GiB
arm64
unknown
amd64
unknown
Settings to fill in
none
Listing
Community template

About CockroachDB

A distributed SQL database that speaks the Postgres wire protocol, run as one insecure node for development and small workloads. The SQL port is private, the admin console is the web page. Source available license.

What it deploys

CockroachDB runs as one service in a single Compose app, listening on ports 8080, 26257, with 1 named volume mount.

ServiceImageTagPortsVolumes
cockroachdb cockroachdb/cockroach v24.3.1 8080, 26257 cockroach_data -> /cockroach/cockroach-data

Before you install

  • CPU architecture. arm64 unknown. The scan could not read a manifest or the tag is chosen at install time. This is not a claim either way.
  • Listed. It is in the catalog. Back up the data volume before changing an image tag.

Settings and environment

The catalog lists no environment variables for this template.

First run

  1. Open the admin console, and connect clients from this project to cockroachdb:26257 as root with no password.

Install CockroachDB on a VPS

  1. Install Levelrail on a fresh VPS

    Run this as root on a Linux server (amd64 or arm64) with ports 80 and 443 reachable. The installer prints a setup link.

    curl -fsSL https://levelrail.com/install.sh | sudo sh
  2. Sign in

    Open the setup link, choose a password, then log the CLI in. The CLI install command is curl -fsSL https://levelrail.com/install-cli.sh | sh if the machine does not have it. See Getting started.

    levelrail-cli login --device
  3. Read the template

    Shows the entry, including its full compose.yaml.

    levelrail-cli templates get cockroachdb
  4. Deploy it

    This deploys the template compose file as an app. The app name defaults to the template id; --name sets another.

    levelrail-cli templates deploy cockroachdb --name my-cockroachdb

Without a domain the app gets an sslip.io address. You can also deploy it from the dashboard: Apps, New app, Browse templates, then CockroachDB.

More in Database Tools

All Database Tools templates