create_configuration.sql

# load extension
CREATE EXTENSION tsearch2;

# add permission
GRANT ALL ON pg_ts_config to USER_NAME;
GRANT ALL ON pg_ts_config_map to USER_NAME;
GRANT ALL ON pg_ts_dict to USER_NAME;
GRANT ALL ON pg_ts_parser to USER_NAME;

# create configuration
CREATE TEXT SEARCH CONFIGURATION public.default_german ( COPY = pg_catalog.german );

# create ispell dictionary
CREATE TEXT SEARCH DICTIONARY german_ispell (
  TEMPLATE  = ispell,
  DictFile  = german_fulltext,
  AffFile   = german_fulltext,
  StopWords = german_fulltext
);

# setup tokens with ispell and stem dictionaries.
ALTER TEXT SEARCH CONFIGURATION default_german
ALTER MAPPING FOR
  asciiword, asciihword, hword_asciipart,
  word, hword, hword_part, hword_numpart,
  numword, numhword
WITH german_ispell, german_stem;

# setup some tokens with simple dictionary.
ALTER TEXT SEARCH CONFIGURATION default_german
ALTER MAPPING FOR
  host, file, int, uint, version
WITH simple;

# drop some tokens from default setting
ALTER TEXT SEARCH CONFIGURATION default_german
DROP MAPPING FOR
  email, url, url_path, sfloat, float;