RisingWave on Ubuntu 24.04 LTS

RisingWave on Ubuntu 24.04 LTS

RisingWave is an Apache-2.0 licensed distributed SQL streaming database that lets you ingest, process, and serve real-time data using standard PostgreSQL syntax and materialized views. This image is built and maintained by cloudimg on a hardened, fully patched Ubuntu 24.04 LTS base.

### What's included

• RisingWave single-node deployment, managed by systemd
• PostgreSQL wire protocol on port 4566, bound to loopback for security
• A unique `root` password generated on first boot (no shared default credential)
• Streaming state and data stored on a dedicated managed data disk
• Automatic security updates enabled

### Getting started

Retrieve the generated password with `sudo cat /root/risingwave-credentials.txt`, then connect with any PostgreSQL client: `psql -h 127.0.0.1 -p 4566 -U root`. Create sources, materialized views, and sinks using standard SQL. The deployment guide on cloudimg.co.uk walks through a streaming demo and day-2 operations.