Check against your doze
Checking against doze
PostgreSQL
OfficialSignedReal local Postgres, declared not scripted.
doze/postgres$ doze add postgres- Newest
- 0.2.4 · 2 Nov 2026
- Needs
- any doze
- Runs
- Postgres 14 – 18
- Platforms
- macOS arm64 · Linux arm64 · Linux x86_64
- Licence
- Apache-2.0
- Source
- doze-modules
Extensions for Postgres, by name
Write a name; doze fetches the build for your Postgres and your machine. Each extension is built per version, per Postgres major and per platform, checked against its digest and pinned in doze.lock, like the engine itself. Ones that must be preloaded are added to shared_preload_libraries for you.
module postgres "postgres" { version = 17 extensions = ["vector", "pg_cron"] } module postgres "metrics" { version = 17 extension "timescaledb" { version = "2.31" } # pinned }
By Postgres version
| Extension | PG 14 | PG 15 | PG 16 | PG 17 | PG 18 | Preload | Licence | What it's for |
|---|---|---|---|---|---|---|---|---|
| Wave 1 | Coming in postgres 0.3 · built and tested on a branch | |||||||
| vectorpgvector | 0.8.7 | 0.8.7 | 0.8.7 | 0.8.7 | 0.8.7 | no | PostgreSQL | Vector similarity search for embeddings (HNSW, IVFFlat) |
| pg_cron | 1.6.8 | 1.6.8 | 1.6.8 | 1.6.8 | 1.6.8 | preloads | PostgreSQL | Cron-style jobs run inside the database |
| pg_partman | 5.5.0 | 5.5.0 | 5.5.0 | 5.5.0 | 5.5.0 | bgw, off | PostgreSQL | Time- and serial-based partition management |
| pgmq | 1.13.1 | 1.13.1 | 1.13.1 | 1.13.1 | 1.13.1 | no | PostgreSQL | Lightweight message queues, like SQS, in tables |
| hypopg | 1.4.5 | 1.4.5 | 1.4.5 | 1.4.5 | 1.4.5 | no | PostgreSQL | Hypothetical indexes: see what an index would do |
| pg_hint_plan | 1.4.5 | 1.5.4 | 1.6.3 | 1.7.2 | 1.8.1 | preloads | BSD-3 | Steer the planner with hints in SQL comments |
| pg_repack+ CLI | 1.5.3 | 1.5.3 | 1.5.3 | 1.5.3 | 1.5.3 | no | BSD-3 | Rebuild bloated tables and indexes online |
| pgaudit | 1.6.3 | 1.7.1 | 16.1 | 17.1 | 18.0 | preloads | PostgreSQL | Session and object audit logging |
| pg_ivm | 1.17 | 1.17 | 1.17 | 1.17 | 1.17 | preloads | PostgreSQL | Incrementally maintained materialized views |
| pg_jsonschema | 0.3.4 | 0.3.4 | 0.3.4 | 0.3.4 | 0.3.4 | no | Apache-2.0 | JSON Schema validation for json and jsonb |
| Wave 2 | planned [to confirm] · not in doze-binaries' catalog yet | |||||||
| postgis+ h3 4.2, pgrouting 3.8 | 3.6 | 3.6 | 3.6 | 3.6 | 3.6 | no | GPL-2.0 | Geographic objects, spatial indexes and functions |
| timescaledbtimescale | × | 2.31 | 2.31 | 2.31 | 2.31 | preloads | Apache-2.0 | Hypertables and time_bucket (Apache-only build) |
| pg_searchParadeDB | × | 0.20 | 0.20 | 0.20 | 0.20 | preloads | AGPL-3.0 | BM25 full-text search |
| pg_duckdb | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | preloads | MIT | DuckDB inside Postgres: analytics, Parquet, Iceberg |
| vectorscalepgvectorscale | ? | ? | ? | ? | 0.9 | no | PostgreSQL | DiskANN indexes for pgvector at scale |
| ageApache AGE | 1.5 | 1.5 | 1.5 | 1.6 | 1.6 | optional | Apache-2.0 | Graph database with openCypher queries |
| No extension matches these filters. | ||||||||
Versions are each extension's own, from doze-binaries' catalog. pg_hint_plan and pgaudit cut one line per Postgres major, so the version changes across the row. TimescaleDB and pg_search start at 15 upstream; pgvectorscale is verified on 18 only. Postgres 14 reaches end of life upstream on 12 Nov 2026; pinned 14 builds stay served.
doze has no extension vectr for Postgres 17; did you mean vector?Aliases work too: pgvector → vector, timescale → timescaledb, pgvectorscale → vectorscale. Names PostGIS provides (postgis_topology, postgis_raster…) resolve to its bundle.Ships with Postgres 44
The contrib extensions are inside every Postgres doze runs: nothing to fetch, nothing to pin. List them the same way: extensions = ["pg_trgm", "citext"].
pg_trgmuuid-ossphstorecitextpgcryptobtree_ginbtree_gistpg_stat_statementspostgres_fdwltreeunaccentfuzzystrmatchtablefuncintarraycubeearthdistancedblinkamcheckbloompg_buffercachepg_prewarmpageinspectpgstattuplepgrowlockspg_visibilitypg_freespacemappg_surgeryfile_fdwisnlosegintaggmoddatetimeautoincinsert_usernamerefinttcnsslinfotsm_system_rowstsm_system_timedict_intdict_xsynxml2plpgsqlBy version: pg_walinspect from 15, pg_logicalinspect from 18; adminpack and old_snapshot up to 16.