pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Install Tsearch2
8+ messages / 5 participants
[nested] [flat]

* Install Tsearch2
@ 2007-02-01 19:16 Alexander B. <burbello3000@yahoo.com.br>
  2007-02-01 19:25 ` Re: Install Tsearch2 Jeff Frost <jeff@frostconsultingllc.com>
  2007-02-01 19:28 ` Re: Install Tsearch2 Shoaib Mir <shoaibmir@gmail.com>
  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:16 Install Tsearch2 Alexander B. <burbello3000@yahoo.com.br>
@ 2007-02-01 19:25 ` Jeff Frost <jeff@frostconsultingllc.com>
  2007-02-01 19:32   ` Re: Install Tsearch2 Jeff Frost <jeff@frostconsultingllc.com>
  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:16 Install Tsearch2 Alexander B. <burbello3000@yahoo.com.br>
  2007-02-01 19:25 ` Re: Install Tsearch2 Jeff Frost <jeff@frostconsultingllc.com>
@ 2007-02-01 19:32   ` Jeff Frost <jeff@frostconsultingllc.com>
  2007-02-02 12:05     ` Re: Install Tsearch2 Alexander B. <burbello3000@yahoo.com.br>
  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-01 19:16 Install Tsearch2 Alexander B. <burbello3000@yahoo.com.br>
  2007-02-01 19:25 ` Re: Install Tsearch2 Jeff Frost <jeff@frostconsultingllc.com>
  2007-02-01 19:32   ` Re: Install Tsearch2 Jeff Frost <jeff@frostconsultingllc.com>
@ 2007-02-02 12:05     ` Alexander B. <burbello3000@yahoo.com.br>
  2007-02-02 12:23       ` Re: Install Tsearch2 Achilleas Mantzios <achill@matrix.gatewaynet.com>
  2007-02-02 13:53       ` Re: Install Tsearch2 Peter Eisentraut <peter_e@gmx.net>
  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-01 19:16 Install Tsearch2 Alexander B. <burbello3000@yahoo.com.br>
  2007-02-01 19:25 ` Re: Install Tsearch2 Jeff Frost <jeff@frostconsultingllc.com>
  2007-02-01 19:32   ` Re: Install Tsearch2 Jeff Frost <jeff@frostconsultingllc.com>
  2007-02-02 12:05     ` Re: Install Tsearch2 Alexander B. <burbello3000@yahoo.com.br>
@ 2007-02-02 12:23       ` Achilleas Mantzios <achill@matrix.gatewaynet.com>
  2007-02-02 13:40         ` Re: Install Tsearch2 Shoaib Mir <shoaibmir@gmail.com>
  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-01 19:16 Install Tsearch2 Alexander B. <burbello3000@yahoo.com.br>
  2007-02-01 19:25 ` Re: Install Tsearch2 Jeff Frost <jeff@frostconsultingllc.com>
  2007-02-01 19:32   ` Re: Install Tsearch2 Jeff Frost <jeff@frostconsultingllc.com>
  2007-02-02 12:05     ` Re: Install Tsearch2 Alexander B. <burbello3000@yahoo.com.br>
  2007-02-02 12:23       ` Re: Install Tsearch2 Achilleas Mantzios <achill@matrix.gatewaynet.com>
@ 2007-02-02 13:40         ` Shoaib Mir <shoaibmir@gmail.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-01 19:16 Install Tsearch2 Alexander B. <burbello3000@yahoo.com.br>
  2007-02-01 19:25 ` Re: Install Tsearch2 Jeff Frost <jeff@frostconsultingllc.com>
  2007-02-01 19:32   ` Re: Install Tsearch2 Jeff Frost <jeff@frostconsultingllc.com>
  2007-02-02 12:05     ` Re: Install Tsearch2 Alexander B. <burbello3000@yahoo.com.br>
@ 2007-02-02 13:53       ` Peter Eisentraut <peter_e@gmx.net>
  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

* Re: Install Tsearch2
  2007-02-01 19:16 Install Tsearch2 Alexander B. <burbello3000@yahoo.com.br>
@ 2007-02-01 19:28 ` Shoaib Mir <shoaibmir@gmail.com>
  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


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