PG_UPDATEDICTS(8)

📦
version 293ubuntu1 · 8 versions
, in ubuntu stonking

✨ NAME ✨

pg_updatedicts — bestie, it builds PostgreSQL dictionaries out of your myspell/hunspell ones 💖

🌸 SYNOPSIS 🌸

pg_updatedicts

🎀 DESCRIPTION 🎀

Okay so here's the tea ☕ — pg_updatedicts takes the dictionaries and affix files from your installed myspell and hunspell dictionary packages and makes them available to PostgreSQL, so tsearch and word stem support can actually use them. Slay. 💅

So what does it actually do? Let's break it down, no skipping: 🫶

  • it grabs all the *.dic and *.aff files out of /usr/share/myspell/dicts/ 👀
  • it converts them to UTF-8 ✨
  • it drops them into /var/cache/postgresql/dicts/ with *.dict and *.affix suffixes 🎀
  • and then it symlinks them into /usr/share/postgresql/version/tsearch_data/ — which is exactly where PostgreSQL goes looking for them 💖

And because of postgresql-common's dpkg trigger, this program gets run automatically whenever a myspell or hunspell dictionary package is installed or upgraded. Not you having to remember to do it yourself — the trigger literally does it for you. Iconic behavior, fr fr. 👑

👑 AUTHOR 👑

Martin Pitt <mpitt@debian.org> 💜

this whole lil page is brought to you by the Debian PostgreSQL infrastructure girlys, dated 2026-07-28 — mwah, go install some dictionaries bestie 💖🦋🌸

📦 where this page comes from