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; |