Apache AGE on Ubuntu 24.04 LTS

Apache AGE on Ubuntu 24.04 LTS

Apache AGE is a PostgreSQL extension that brings graph database capabilities — the openCypher query language, graph storage, and traversal — to a standard PostgreSQL server, so you can combine relational SQL and graph queries in one database. This image is built and maintained by cloudimg on a hardened, fully patched Ubuntu 24.04 LTS base.

### What's included

• PostgreSQL with the Apache AGE extension installed and enabled, managed by systemd
• PostgreSQL bound to loopback (port 5432) for security
• A seeded demo graph so Cypher queries return data out of the box
• A unique database password generated on first boot (no shared default credential)
• Database storage on a dedicated managed data disk
• Automatic security updates enabled

### Getting started

Retrieve the generated password with `sudo cat /root/age-credentials.txt`, then connect with psql: `PGPASSWORD=<password> psql -h 127.0.0.1 -U age -d demo`. Run `LOAD 'age';` and query the demo graph with Cypher via `cypher('demo', $$ MATCH (n) RETURN n $$)`. The deployment guide on cloudimg.co.uk covers graph creation and Cypher.