PostgreSQL Extensions

Aidbox requires specific PostgreSQL extensions to function properly. There are required and optional PostgreSQL extensions:

• If any required extensions are missing, Aidbox won’t start.

• Optional extensions enhance functionality but are not critical. Missing optional extensions will trigger a warning at startup.

Required PostgreSQL extensions

• unaccent — A text search dictionary that removes diacritics. Used in some searches.

• pg_trgm — Support for similarity of text using trigram matching. Useful for some indexes.

• fuzzystrmatch — String similarities functions. Used by MDM module only.

• pgcrypto

Optional PostgreSQL extensions

• jsonknife — Useful functions for jsonb. It was the only way to create complex search queries in jsonb before PostgreSQL 12 (jsonpath support).

• pg_similarity — Support similarity queries. Used by MDM module only.

• pgagent — A PostgreSQL job scheduler.

• pg_stat_statements — Track statistics.

• postgis — Support storing, indexing, and querying geographic data. Used by _location search parameter only.