Base
Hardened build
minimal ports, security patches applied at build time
SPQR 3.0 Sharding Router for PostgreSQL on Ubuntu 24.04 LTS
Azure
Databases
a stateless query router that shards and routes PostgreSQL traffic across backends, ready to route the moment it boots.
Overview
SPQR (Stateless Postgres Query Router) speaks the PostgreSQL wire protocol and transparently routes and pools client queries across a set of PostgreSQL shards by a sharding key. It lets a database grow horizontally: rows are distributed across shards by key ranges, and applications keep talking to a single endpoint while the router decides which shard each query belongs to.
Why the cloudimg image
cloudimg ships SPQR preconfigured on a hardened, fully patched base as a single node appliance: one PostgreSQL backend hosting two shard databases fronted by the router with its embedded coordinator and an in memory metadata store, so no separate cluster is required. Unique passwords for the router, the shard role, and the database superuser are generated on first boot with no default login, every client connection is encrypted with a per instance TLS certificate, and 24/7 support is included.
Common uses
- Horizontal sharding for PostgreSQL
- Routing and pooling in front of database backends
- Scaling write heavy application databases