documentdb

API surface for DocumentDB for PostgreSQL

Overview

PackageVersionCategoryLicenseLanguage
documentdb0.109SIMMITC
IDExtensionBinLibLoadCreateTrustRelocSchema
9000documentdbNoYesYesYesNoNo-
9010documentdb_coreNoYesYesYesNoNo-
9020documentdb_distributedNoYesYesYesNoNo-
9030documentdb_extended_rumNoYesYesYesNoYes-
Relateddocumentdb_core pg_cron tsm_system_rows vector postgis rum mongo_fdw wal2mongo pg_jsonschema jsquery
Depended Bydocumentdb_distributed

Version

TypeRepoVersionPG VerPackageDeps
EXTPIGSTY0.1091817161514documentdbdocumentdb_core, pg_cron, tsm_system_rows, vector, postgis, rum
RPMPIGSTY0.1091817161514documentdb_$vpostgresql$v-contrib, pg_cron_$v, pgvector_$v, rum_$v
DEBPIGSTY0.1091817161514postgresql-$v-documentdbpostgresql-$v-cron, postgresql-$v-pgvector, postgresql-$v-rum
OS / PGPG18PG17PG16PG15PG14
el8.x86_64PIGSTY MISS
el8.aarch64PIGSTY MISS
el9.x86_64PIGSTY MISS
el9.aarch64PIGSTY MISS
el10.x86_64PIGSTY MISS
el10.aarch64PIGSTY MISS
d12.x86_64PIGSTY MISS
d12.aarch64
PIGSTY 0.109
PIGSTY 0.109
PIGSTY 0.109
PIGSTY 0.109
PIGSTY MISS
d13.x86_64PIGSTY MISS
d13.aarch64PIGSTY MISS
u22.x86_64
PIGSTY 0.109
PIGSTY 0.109
PIGSTY 0.109
PIGSTY 0.109
PIGSTY MISS
u22.aarch64
PIGSTY 0.109
PIGSTY 0.109
PIGSTY 0.109
PIGSTY 0.109
PIGSTY MISS
u24.x86_64
PIGSTY 0.109
PIGSTY 0.109
PIGSTY 0.109
PIGSTY 0.109
PIGSTY MISS
u24.aarch64
PIGSTY 0.109
PIGSTY 0.109
PIGSTY 0.109
PIGSTY 0.109
PIGSTY MISS

Build

You can build the RPM / DEB packages for documentdb using pig build:

pig build pkg documentdb         # build RPM / DEB packages

Install

You can install documentdb directly. First, make sure the PGDG and PIGSTY repositories are added and enabled:

pig repo add pgsql -u          # Add repo and update cache

Install the extension using pig or apt/yum/dnf:

pig install documentdb;          # Install for current active PG version
pig ext install -y documentdb -v 18  # PG 18
pig ext install -y documentdb -v 17  # PG 17
pig ext install -y documentdb -v 16  # PG 16
pig ext install -y documentdb -v 15  # PG 15
dnf install -y documentdb_18       # PG 18
dnf install -y documentdb_17       # PG 17
dnf install -y documentdb_16       # PG 16
dnf install -y documentdb_15       # PG 15
apt install -y postgresql-18-documentdb   # PG 18
apt install -y postgresql-17-documentdb   # PG 17
apt install -y postgresql-16-documentdb   # PG 16
apt install -y postgresql-15-documentdb   # PG 15

Preload:

shared_preload_libraries = 'pg_documentdb, pg_documentdb_core, pg_cron';

Create Extension:

CREATE EXTENSION documentdb CASCADE;  -- requires: documentdb_core, pg_cron, tsm_system_rows, vector, postgis, rum

Usage

Add to shared_preload_libraries first:

shared_preload_libraries = 'pg_documentdb_core, pg_stat_statements, auto_explain'

Example, create extension and perform DDL & CRUD

-- CASCADE will install documentdb_core, pg_cron, vector, etc.
CREATE EXTENSION IF NOT EXISTS documentdb CASCADE;

Currently, DocumentDB can be used with FerretDB 2.0+ as a MongoDB-compatible backend.


Last Modified 2026-03-12: add pg extension catalog (95749bf)