PostgreSQL with PostGIS + pgvector, built on the official postgis/postgis Alpine image.
| Extension | Version | Purpose |
|---|---|---|
| PostGIS | via base image | Geospatial queries |
| postgis_topology | via base image | Topology support |
| postgis_raster | via base image | Raster data support |
| pgvector | 0.8.3 | Vector similarity search (AI embeddings) |
Extensions are enabled automatically on first database initialization.
| Tag | PostgreSQL | PostGIS |
|---|---|---|
latest | 18 | 3.6 |
pg18-postgis3.6 | 18 | 3.6 |
pg17-latest | 17 | 3.6 |
pg17-postgis3.6 | 17 | 3.6 |
pg16-latest | 16 | 3.5 |
pg16-postgis3.5 | 16 | 3.5 |
Platform: linux/amd64
docker run -d \
--name mydb \
-e POSTGRES_PASSWORD=secret \
-p 5432:5432 \
mgle/postgres-ai:latest
services:
db:
image: mgle/postgres-ai:latest
environment:
POSTGRES_USER: postgres
POSTGRES_PASSWORD: secret
POSTGRES_DB: mydb
ports:
- "5432:5432"
volumes:
- pg_data:/var/lib/postgresql
volumes:
pg_data:
PG 18+: use /var/lib/postgresql as the volume mount (not /var/lib/postgresql/data).
Verify:
\dx
-- postgis, postgis_topology, postgis_raster, vector
Content type
Image
Digest
sha256:3f571c180…
Size
181.9 MB
Last updated
3 days ago
docker pull mgle/postgres-ai