PostgreSQL Extensions
Last updated
Was this helpful?
Last updated
Was this helpful?
Aidbox requires specific PostgreSQL extensions to function properly.
If any required extensions are missing, Aidbox wonβt start.
β A text search dictionary that removes diacritics. Used in some searches.
β Provides trigram matching support for text similarity. Useful for some indexes.
β Implements string similarity functions such as Levenshtein. Used by the only.
β Provides cryptographic functions for data encryption and hashing
Optional extensions enhance functionality but are not critical. Missing optional extensions will trigger a warning at startup.
β Provides useful functions for jsonb operations. Particularly important for complex search queries in older PostgreSQL versions (pre-12) without native .
β Support similarity queries. Used by the only.
β A job scheduling system that allows automating database maintenance tasks
β Tracks execution statistics of SQL statements, useful for performance monitoring and troubleshooting
β Adds support for storing, indexing, and querying geographic data, required only when using the Location.near
search parameter
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.