PostgreSQL Extensions

Aidbox requires specific PostgreSQL extensions to function properly.

Required PostgreSQL extensions

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

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

• pg_trgm — Provides trigram matching support for text similarity. Useful for some indexes.

• fuzzystrmatch — Implements string similarity functions such as Levenshtein. Used by the MDM module only.

• pgcrypto — Provides cryptographic functions for data encryption and hashing

Optional PostgreSQL extensions

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

• jsonknife — Provides useful functions for jsonb operations. Particularly important for complex search queries in older PostgreSQL versions (pre-12) without native jsonpath support.

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

• pgagent — A job scheduling system that allows automating database maintenance tasks

• pg_stat_statements — Tracks execution statistics of SQL statements, useful for performance monitoring and troubleshooting

• postgis — Adds support for storing, indexing, and querying geographic data, required only when using the Location.near search parameter

Installation Notes

Most of these extensions are included in standard PostgreSQL distributions. The AidboxDB distribution comes with all required extensions pre-installed. For standard PostgreSQL installations, you may need to install some extensions manually using the CREATE EXTENSION command or through your package manager. For cloud-managed PostgreSQL services, consult your provider's documentation about supported extensions and how to enable them.