Re: ADMIN Install Tsearch2 - new dic - Mailing list pgsql-admin

Le vendredi 2 février 2007 17:28, Alexander B. a écrit :
> Sorry for insist, but how can I add a new language, specially portuguese?
> I could execute the file "tsearch2.sql", but I need to configure in my
> language.
you should look at the tsearch2 site, there is a lot of info.
in few steps :
  - use ispell dictionnaries (.aff and .dict files and stop word)
  - and/or use stemmer, make your own dictionnary using 'gendict' tool inside
tsearch2 contrib ( if you use 8.2.x you have to patch tsearch2 in order to be
abble to use the new stemmer library)
  - insert/update your pg_ts_cfg ..cfgmap ..dict .. (see tsearch2 site)

>
> Thanks in advance.
>
> Jeff Frost escreveu:
> > BTW, this was for an RPM installed version of postgresql. As Shoab
> > mentions in another mail, if you have compiled postgresql from
> > tarball, you'll have to cd into the contrib/tsearch2 dir and make &&
> > make install before you can do this stuff.
> >
> > On Thu, 1 Feb 2007, Jeff Frost wrote:
> >> I believe I followed these instructions the last time I enabled
> >> tsearch2:
> >>
> >> http://www.sai.msu.su/~megera/wiki/tsearch-v2-intro
> >>
> >> These are my crib notes for the English version, you'll have to
> >> update paths etc:
> >>
> >> wget
> >> http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/dicts/ispell/ispe
> >>ll-english.tar.gz
> >>
> >> cd /usr/local/lib
> >> sudo tar xvfz /usr/local/src/TARFILES/ispell-english.tar.gz
> >>
> >> psql -f /usr/share/pgsql/contrib/tsearch2.sql ftstest
> >>
> >> INSERT INTO pg_ts_cfg (ts_name , prs_name, locale ) values (
> >> 'default_english', 'default', 'en_US');
> >>
> >> INSERT INTO pg_ts_dict
> >> (SELECT 'en_ispell',
> >> dict_init,
> >> 'DictFile="/usr/local/lib/english.dict",'
> >> 'AffFile="/usr/local/lib/english.aff",'
> >> 'StopFile="/usr/share/pgsql/contrib/english.stop"',
> >> dict_lexize
> >> FROM pg_ts_dict
> >> WHERE dict_name = 'ispell_template');
> >>
> >> INSERT INTO pg_ts_cfgmap (ts_name, tok_alias, dict_name)
> >> VALUES ('default_english', 'lhword', '{en_ispell,en_stem}');
> >> INSERT INTO pg_ts_cfgmap (ts_name, tok_alias, dict_name)
> >> VALUES ('default_english', 'lpart_hword', '{en_ispell,en_stem}');
> >> INSERT INTO pg_ts_cfgmap (ts_name, tok_alias, dict_name)
> >> VALUES ('default_english', 'lword', '{en_ispell,en_stem}');
> >>
> >> INSERT INTO pg_ts_cfgmap
> >> VALUES ('default_english', 'url', '{simple}');
> >> INSERT INTO pg_ts_cfgmap
> >> VALUES ('default_english', 'host', '{simple}');
> >> INSERT INTO pg_ts_cfgmap
> >> VALUES ('default_english', 'sfloat', '{simple}');
> >> INSERT INTO pg_ts_cfgmap
> >> VALUES ('default_english', 'uri', '{simple}');
> >> INSERT INTO pg_ts_cfgmap
> >> VALUES ('default_english', 'int', '{simple}');
> >> INSERT INTO pg_ts_cfgmap
> >> VALUES ('default_english', 'float', '{simple}');
> >> INSERT INTO pg_ts_cfgmap
> >> VALUES ('default_english', 'email', '{simple}');
> >> INSERT INTO pg_ts_cfgmap
> >> VALUES ('default_english', 'word', '{simple}');
> >> INSERT INTO pg_ts_cfgmap
> >> VALUES ('default_english', 'hword', '{simple}');
> >> INSERT INTO pg_ts_cfgmap
> >> VALUES ('default_english', 'nlword', '{simple}');
> >> INSERT INTO pg_ts_cfgmap
> >> VALUES ('default_english', 'nlpart_hword', '{simple}');
> >> INSERT INTO pg_ts_cfgmap
> >> VALUES ('default_english', 'part_hword', '{simple}');
> >> INSERT INTO pg_ts_cfgmap
> >> VALUES ('default_english', 'nlhword', '{simple}');
> >> INSERT INTO pg_ts_cfgmap
> >> VALUES ('default_english', 'file', '{simple}');
> >> INSERT INTO pg_ts_cfgmap
> >> VALUES ('default_english', 'uint', '{simple}');
> >> INSERT INTO pg_ts_cfgmap
> >> VALUES ('default_english', 'version', '{simple}');
> >>
> >> ALTER TABLE album ADD COLUMN idxFTI tsvector;
> >> UPDATE album SET idxFTI=to_tsvector(name);
> >> CREATE INDEX album_idxFTI_idx ON album USING gist(idxFTI);
> >>
> >> CREATE TRIGGER album_tsvectorupdate BEFORE UPDATE OR INSERT ON album
> >> FOR EACH ROW EXECUTE PROCEDURE tsearch2(idxFTI, name);
> >>
> >> SELECT * FROM album WHERE idxfti @@ to_tsquery('spiderman');
> >>
> >>
> >> Hopefully that helps...
> >>
> >> On Thu, 1 Feb 2007, Alexander B. wrote:
> >>> Hi,
> >>>
> >>> I need to install tsearch2, but I couldn't find a procedure
> >>> (step-by-step).
> >>> Could you recomend some site or some steps to install.
> >>>
> >>> I used PG 8 on Suse and Debian, and I installed postgres by source.
> >>>
> >>> Thanks in advance.
> >>>
> >>>
> >>>
> >>>
> >>>
> >>> _______________________________________________________
> >>> Yahoo! Mail - Sempre a melhor op??o para voc?!
> >>> Experimente j? e veja as novidades.
> >>> http://br.yahoo.com/mailbeta/tudonovo/
> >>>
> >>> ---------------------------(end of
> >>> broadcast)---------------------------
> >>> TIP 7: You can help support the PostgreSQL project by donating at
> >>>
> >>> http://www.postgresql.org/about/donate
>
> _______________________________________________________
> Yahoo! Mail - Sempre a melhor opção para você!
> Experimente já e veja as novidades.
> http://br.yahoo.com/mailbeta/tudonovo/
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster