pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedInstall Tsearch2
8+ messages / 5 participants
[nested] [flat]
* Install Tsearch2
@ 2007-02-01 19:16 Alexander B. <burbello3000@yahoo.com.br>
0 siblings, 2 replies; 8+ messages in thread
From: Alexander B. @ 2007-02-01 19:16 UTC (permalink / raw)
To: pgsql-admin
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/
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Install Tsearch2
@ 2007-02-01 19:25 Jeff Frost <jeff@frostconsultingllc.com>
parent: Alexander B. <burbello3000@yahoo.com.br>
1 sibling, 1 reply; 8+ messages in thread
From: Jeff Frost @ 2007-02-01 19:25 UTC (permalink / raw)
To: Alexander B. <burbello3000@yahoo.com.br>; +Cc: pgsql-admin
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
>
>
--
Jeff Frost, Owner <jeff@frostconsultingllc.com>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Install Tsearch2
@ 2007-02-01 19:28 Shoaib Mir <shoaibmir@gmail.com>
parent: Alexander B. <burbello3000@yahoo.com.br>
1 sibling, 0 replies; 8+ messages in thread
From: Shoaib Mir @ 2007-02-01 19:28 UTC (permalink / raw)
To: Alexander B. <burbello3000@yahoo.com.br>; +Cc: pgsql-admin
It already is there in the contrib folder within the source. While in the
tsearch2 folder you just need to do a 'make' and 'make install' and then
then run the tsearch.sql file so that you can register the tsearch2
functions.
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 2/2/07, Alexander B. <burbello3000@yahoo.com.br> 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
>
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Install Tsearch2
@ 2007-02-01 19:32 Jeff Frost <jeff@frostconsultingllc.com>
parent: Jeff Frost <jeff@frostconsultingllc.com>
0 siblings, 1 reply; 8+ messages in thread
From: Jeff Frost @ 2007-02-01 19:32 UTC (permalink / raw)
To: Alexander B. <burbello3000@yahoo.com.br>; +Cc: pgsql-admin
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
>>
>>
>
>
--
Jeff Frost, Owner <jeff@frostconsultingllc.com>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Install Tsearch2
@ 2007-02-02 12:05 Alexander B. <burbello3000@yahoo.com.br>
parent: Jeff Frost <jeff@frostconsultingllc.com>
0 siblings, 2 replies; 8+ messages in thread
From: Alexander B. @ 2007-02-02 12:05 UTC (permalink / raw)
To: pgsql-admin
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/
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Install Tsearch2
@ 2007-02-02 12:23 Achilleas Mantzios <achill@matrix.gatewaynet.com>
parent: Alexander B. <burbello3000@yahoo.com.br>
1 sibling, 1 reply; 8+ messages in thread
From: Achilleas Mantzios @ 2007-02-02 12:23 UTC (permalink / raw)
To: pgsql-admin
Στις Παρασκευή 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
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Install Tsearch2
@ 2007-02-02 13:40 Shoaib Mir <shoaibmir@gmail.com>
parent: Achilleas Mantzios <achill@matrix.gatewaynet.com>
0 siblings, 0 replies; 8+ messages in thread
From: Shoaib Mir @ 2007-02-02 13:40 UTC (permalink / raw)
To: Achilleas Mantzios <achill@matrix.gatewaynet.com>; +Cc: pgsql-admin
yes, you need to just correct the build directory paths...
---
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 2/2/07, Achilleas Mantzios <achill@matrix.gatewaynet.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
>
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Install Tsearch2
@ 2007-02-02 13:53 Peter Eisentraut <peter_e@gmx.net>
parent: Alexander B. <burbello3000@yahoo.com.br>
1 sibling, 0 replies; 8+ messages in thread
From: Peter Eisentraut @ 2007-02-02 13:53 UTC (permalink / raw)
To: pgsql-admin; +Cc: Alexander B. <burbello3000@yahoo.com.br>
Am Freitag, 2. Februar 2007 13:05 schrieb 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 #
Run configure first.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
^ permalink raw reply [nested|flat] 8+ messages in thread
end of thread, other threads:[~2007-02-02 13:53 UTC | newest]
Thread overview: 8+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-02-01 19:16 Install Tsearch2 Alexander B. <burbello3000@yahoo.com.br>
2007-02-01 19:25 ` Jeff Frost <jeff@frostconsultingllc.com>
2007-02-01 19:32 ` Jeff Frost <jeff@frostconsultingllc.com>
2007-02-02 12:05 ` Alexander B. <burbello3000@yahoo.com.br>
2007-02-02 12:23 ` Achilleas Mantzios <achill@matrix.gatewaynet.com>
2007-02-02 13:40 ` Shoaib Mir <shoaibmir@gmail.com>
2007-02-02 13:53 ` Peter Eisentraut <peter_e@gmx.net>
2007-02-01 19:28 ` Shoaib Mir <shoaibmir@gmail.com>
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