About

The official postgres docker with Czech full-text search dictionaries pulled from https://postgres.cz/data/czech.tar.gz.

Supported tags

• 11.6 Based on postgres:11.6

• 9.6

  • Based on dedekj/docker-pgq:9.6.
  • docker pull dedekj/postgres-pgq-tsearch-czech:9.6

• 9.5

  • Based on jtjeferreira/docker-pgq:9.5.
  • docker pull dedekj/postgres-pgq-tsearch-czech:9.5

How to

docker build -t datlowe/postgres-pgq-tsearch-czech:9.6 .

docker run --name postgres -p 5432:5432 -e POSTGRES_PASSWORD=datlowe -e POSTGRES_USER=datlowe datlowe/postgres-pgq-tsearch-czech:9.6

Test it

SELECT * FROM ts_debug('czech', 'psi a psů a lidi a lidí a ruce a vody a Měla cholecystektomii neb cholecystektomie i  mnoho cholecystektomií');

Upgrading from docker-pgq image or for any new database

  create text search dictionary czech_ispell
    (template=ispell, dictfile=czech, afffile=czech, stopwords=czech);
    
  create text search dictionary czech_snowball
    (template=snowball, language=czech, stopwords=czech);
    
  create text search configuration czech (copy=english);
  alter text search configuration czech
    alter mapping for word, asciiword with czech_ispell, czech_snowball;

See also

• https://hub.docker.com/r/dedekj/postgres-pgq-tsearch-czech/
• https://postgres.cz/wiki/Instalace_PostgreSQL#Instalace_Fulltextu
• https://github.com/jtjeferreira/docker-pgq
• http://snowballstem.org/otherapps/oregan/
• https://stackoverflow.com/q/42540638/1857897