Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 487DB9FA43A for ; Fri, 2 Feb 2007 08:06:09 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-new, port 10024) with ESMTP id 96737-03 for ; Fri, 2 Feb 2007 08:05:59 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from smtp103.mail.mud.yahoo.com (smtp103.mail.mud.yahoo.com [209.191.85.213]) by postgresql.org (Postfix) with SMTP id 1623C9F9AFC for ; Fri, 2 Feb 2007 08:06:02 -0400 (AST) Received: (qmail 68864 invoked from network); 2 Feb 2007 12:06:01 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com.br; h=Received:X-YMail-OSG:Message-ID:Date:From:User-Agent:MIME-Version:To:Subject:References:In-Reply-To:Content-Type:Content-Transfer-Encoding; b=SliBfWa9BbhwyzztgIFJifovJ0ORbyGQ8mEZXFVMGU9M+LpKmOWvUqJAq+Bp20/ykRhYeTaoxT266abXiI174MHZmmv7q3sERRwfVzVt6j6j+szf0aTh2iJWvY+/Ft8rOhJjwbziMBx2KsQwNhAMA0YXN/Nxi2/zZ0LACkCFxEc= ; Received: from unknown (HELO ?10.90.2.162?) (burbello3000@200.103.143.8 with plain) by smtp103.mail.mud.yahoo.com with SMTP; 2 Feb 2007 12:06:00 -0000 X-YMail-OSG: 7Rg5uU4VM1nyekBVij8n2RjXbwm.kHU2VTx.7UeZUpOPtPidQENlJ03BOBL0b199.0MuGx88UmVSCoaoAwWhiTB3IAEkf2LEfsuDskRdrtaAV8ZGrNzXwr_.v37WFgpayk8OoxCNPtNI8ahMXyZ3nf_eEHhZ0enTihd6zsuPijZ._WaOfSl6.qTZ9jDL Message-ID: <45C32924.8070203@yahoo.com.br> Date: Fri, 02 Feb 2007 10:05:56 -0200 From: "Alexander B." User-Agent: Thunderbird 1.5.0.7 (X11/20060911) MIME-Version: 1.0 To: "pgsql-admin@postgresql.org" Subject: Re: Install Tsearch2 References: <45C23C9A.70307@yahoo.com.br> In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200702/15 X-Sequence-Number: 24480 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 # 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/ispell-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/