Re: Install Tsearch2

yes, you need to just correct the build directory paths...

---
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)

On 2/2/07, Achilleas Mantzios <achill(at)matrix(dot)gatewaynet(dot)com> wrote:
>
> Στις Παρασκευή 02 Φεβρουάριος 2007 14:05, ο/η Alexander B. έγραψε:
> > I am getting the follow error:
> >
> > analise3:/postgres/share/contrib/tsearch2 # make
> > Makefile:31: ../../src/Makefile.global: No such file or directory
> > Makefile:32: /contrib/contrib-global.mk: No such file or directory
> > make: *** No rule to make target `/contrib/contrib-global.mk'. Stop.
> > analise3:/postgres/share/contrib/tsearch2 #
>
> Edit Makefile and correct the
> top_builddir = ../..
> line to your actual postgresql sources.
>
> >
> >
> > What do I need to do?
> > Thanks
> >
> > Jeff Frost wrote:
> > > 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 3: Have you checked our extensive FAQ?
> >
> > http://www.postgresql.org/docs/faq
>
> --
> Achilleas Mantzios
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: You can help support the PostgreSQL project by donating at
>
> http://www.postgresql.org/about/donate
>