From: Alexander B. <burbello3000@yahoo.com.br>
To: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: Install Tsearch2
Date: Fri, 02 Feb 2007 10:05:56 -0200
Message-ID: <45C32924.8070203@yahoo.com.br> (raw)
In-Reply-To: <Pine.LNX.4.64.0702011131510.6080@discord.home.frostconsultingllc.com>
References: <45C23C9A.70307@yahoo.com.br>
<Pine.LNX.4.64.0702011122110.6080@discord.home.frostconsultingllc.com>
<Pine.LNX.4.64.0702011131510.6080@discord.home.frostconsultingllc.com>
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/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: burbello3000@yahoo.com.br
Subject: Re: Install Tsearch2
In-Reply-To: <45C32924.8070203@yahoo.com.br>
References: <45C23C9A.70307@yahoo.com.br> <Pine.LNX.4.64.0702011122110.6080@discord.home.frostconsultingllc.com> <Pine.LNX.4.64.0702011131510.6080@discord.home.frostconsultingllc.com> <45C32924.8070203@yahoo.com.br>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox