Re: text search in 8.1

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(at)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