Re: text search in 8.1 - Mailing list pgsql-general

From Albe Laurenz
Subject Re: text search in 8.1
Date
Msg-id D960CB61B694CF459DCFB4B0128514C20393818E@exadv11.host.magwien.gv.at
Whole thread Raw
In response to Re: text search in 8.1  (AI Rumman <rummandba@gmail.com>)
List pgsql-general
AI Rumman wrote:
> I have a plan to upgrade database, but right now I have to
> use text search indexing for performance improvement.
>
> Following is the rpm status of my server:
>
> [root@vcrmdev01 ~]# rpm -qa|grep postgres
> postgresql-8.1.11-1.el5_1.1
> postgresql-python-8.1.11-1.el5_1.1
> postgresql-server-8.1.11-1.el5_1.1
> postgresql-libs-8.1.11-1.el5_1.1
> postgresql-contrib-8.1.11-1.el5_1.1
>
>
> Please tell me how can I install textsearch here.

You already have installed it.

It is in the "contrib" package and is called "tsearch2".
Look at the documentation provided - you need to run an SQL
script to install it in the database.

I also recommend using PostgreSQL 8.3 or better where
full text search is in core. Otherwise your upgrade process
will become more difficult.

Yours,
Laurenz Albe

pgsql-general by date:

Previous
From: "Albe Laurenz"
Date:
Subject: Re: What is unsecure postgres languages? How to disable them?
Next
From: "Albe Laurenz"
Date:
Subject: Re: tsearch2 gives NOTICE: word is too long