Обсуждение: text search in 8.1

On Mon, Feb 22, 2010 at 02:47:00PM +0600, AI Rumman wrote:
> Does Postgresql 8.1 support Full Text Search?
> If yes, please provide the link about documentation.

It's available as an add-on, but since 8.1 is so close to its end of
life, consider moving to 8.4 first, or if the project is out past Q3
of this year, to 9.0.

Cheers,
David.
--
David Fetter <david@fetter.org> http://fetter.org/
Phone: +1 415 235 3778  AIM: dfetter666  Yahoo!: dfetter
Skype: davidfetter      XMPP: david.fetter@gmail.com
iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate

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