postgres-postgis-pgvector

PostgreSQL 18.6 with the PostGIS 3.6 and pgvector 0.8.6 extensions preinstalled, in a single Docker image.

Why

Several projects need the same combination of PostgreSQL + PostGIS + pgvector for geospatial and vector-similarity workloads. Rather than duplicating the same Dockerfile across every repository, this image is built once and published to a public registry so it can be pulled and reused as-is.

What's inside

• PostgreSQL 18.6 (base image: postgis/postgis:18-3.6, pinned by digest)
• PostGIS 3.6
• pgvector 0.8.6 (postgresql-18-pgvector=0.8.6-1.pgdg13+1)

Platform: linux/amd64 only.

Available tags

Tag	Description
latest	Latest published build
18.6-postgis3.6-pgvector0.8.6	PostgreSQL 18.6 + PostGIS 3.6 + pgvector 0.8.6 (recommended, immutable)
vX.Y.Z	A specific release, matching the git tag it was built from

Images are published to GitHub Container Registry: ghcr.io/biggora/postgres-postgis-pgvector.

Quick start

docker run -d \
  --name db \
  -e POSTGRES_USER=app \
  -e POSTGRES_PASSWORD=app \
  -e POSTGRES_DB=app \
  -p 5432:5432 \
  ghcr.io/biggora/postgres-postgis-pgvector:18.6-postgis3.6-pgvector0.8.6

Then enable the extensions you need:

CREATE EXTENSION IF NOT EXISTS postgis;
CREATE EXTENSION IF NOT EXISTS vector;

Docker Compose

See docker-compose.example.yml for a minimal working example:

docker compose -f docker-compose.example.yml up -d

Building locally

docker build -t postgres-postgis-pgvector:local .

Run the smoke test against your local build:

bash test/smoke-test.sh postgres-postgis-pgvector:local

License

MIT