Nhost pg_search icu tokenizer missing: install the extension first
Shows how to fix nhost pg_search icu tokenizer missing: install the extension first. Use it when you hit this exact problem. Skip it when your error message or symptom looks different.
TL;DR
Check SELECT * FROM pgextension for pgsearch before assuming the tokenizer is broken.
Steps
- If Nhost's Postgres says type icu does not exist when using pgsearch tokenizers, two things must both be true: the database must be on a recent image (17.9 or later, where the maintainer fixed the packaging) and pgsearch must actually be installed with CREATE EXTENSION in that database. Check SELECT * FROM pgextension for pgsearch before assuming the tokenizer is broken. The same applies to other extensions Nhost ships but does not enable by default.
When to use
Use this skill when you run into "Nhost pg_search icu tokenizer missing: install the extension first".
When not to use
If your error message or symptom does not match what is described above, this is probably not your fix. Search for your exact error text instead of forcing this one to fit.
Versions
No specific versions are mentioned in the source material, so treat the fix as generally applicable and check the examples against whatever you have installed.
Why this happens
The original report does not dig into a root cause. It documents the symptom and the fix that resolved it.
Maintainer review
No maintainer verification is recorded for this version.
This records the version a maintainer checked. It does not assert that the version is the latest upstream release.