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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general