How to create an ispell dictionary in Postgresql FTS

How to create an ispell dictionary in Postgresql FTS

The following will add without a stop file. The files in tsearch_data are ispell_english.dict and english.affix. Some things to be aware of are selinux and utf-8 encoding.

CREATE TEXT SEARCH DICTIONARY english_ispell (
TEMPLATE = ispell,
DictFile = ispell_english,
AffFile = english
);

After you add the dictionary you probably want to add or update the text search configuration. If the configuration is "pg" do something like:

ALTER TEXT SEARCH CONFIGURATION pg drop MAPPING FOR asciiword, asciihword;
ALTER TEXT SEARCH CONFIGURATION pg ADD MAPPING FOR asciiword, asciihword WITH english_ispell, english_stem;