PostgreSQL Extensions

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

• If anyrequiredextensions are missing, Aidbox won’t start.
• Optionalextensions 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.