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

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.

On Mon, Feb 22, 2010 at 3:20 PM, David Fetter <david@fetter.org> wrote:

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