Constructive Docker

Lean PostgreSQL 17 image with essential extensions for modern applications.

Extensions

Extension	Description
pgvector	Vector similarity search for embeddings
PostGIS	Spatial and geographic data
pg_textsearch	BM25 full-text search
pgsodium	Encryption using libsodium

Usage

# Pull the image
docker pull ghcr.io/constructive-io/docker:latest

# Run
docker run -d \
  --name postgres \
  -e POSTGRES_PASSWORD=secret \
  -p 5432:5432 \
  ghcr.io/constructive-io/docker:latest

Enable extensions as needed:

CREATE EXTENSION vector;
CREATE EXTENSION postgis;
CREATE EXTENSION pg_textsearch;
CREATE EXTENSION pgsodium;

Build

make build    # Build image
make test     # Build and verify extensions
make run      # Run container
make shell    # psql into container
make clean    # Remove image