Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 1FF059FA43A for ; Fri, 2 Feb 2007 08:23:44 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024) with ESMTP id 79061-03 for ; Fri, 2 Feb 2007 08:23:38 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from matrix.gatewaynet.com (host2.dynacom.ondsl.gr [62.103.35.210]) by postgresql.org (Postfix) with ESMTP id 751459F9AFC for ; Fri, 2 Feb 2007 08:23:37 -0400 (AST) Received: from host3.dynacom.ondsl.gr ([62.103.35.211] helo=ip216.internal.net) by matrix.gatewaynet.com with esmtp (Exim 4.62) (envelope-from ) id 1HCxRz-0001aE-TS for pgsql-admin@postgresql.org; Fri, 02 Feb 2007 14:23:31 +0200 From: Achilleas Mantzios Organization: Dynacom Tankers Mgmt To: pgsql-admin@postgresql.org Subject: Re: Install Tsearch2 Date: Fri, 2 Feb 2007 14:23:30 +0200 User-Agent: KMail/1.9.3 References: <45C23C9A.70307@yahoo.com.br> <45C32924.8070203@yahoo.com.br> In-Reply-To: <45C32924.8070203@yahoo.com.br> MIME-Version: 1.0 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Message-Id: <200702021423.31247.achill@matrix.gatewaynet.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200702/16 X-Sequence-Number: 24481 =CE=A3=CF=84=CE=B9=CF=82 =CE=A0=CE=B1=CF=81=CE=B1=CF=83=CE=BA=CE=B5=CF=85= =CE=AE 02 =CE=A6=CE=B5=CE=B2=CF=81=CE=BF=CF=85=CE=AC=CF=81=CE=B9=CE=BF=CF= =82 2007 14:05, =CE=BF/=CE=B7 Alexander B. =CE=AD=CE=B3=CF=81=CE=B1=CF=88= =CE=B5: > 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 =3D ../.. 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/is= pe > >>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=3D"/usr/local/lib/english.dict",' > >> 'AffFile=3D"/usr/local/lib/english.aff",' > >> 'StopFile=3D"/usr/share/pgsql/contrib/english.stop"', > >> dict_lexize > >> FROM pg_ts_dict > >> WHERE dict_name =3D '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=3Dto_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=C3=A7=C3=A3o para voc=C3=AA! > Experimente j=C3=A1 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 =2D-=20 Achilleas Mantzios