Install Full Text Search using Tsearch2
If you want full text search, and you are running PostgreSQL, install this module to support FTS. Do this step after you have installed both PostgreSQL and
- AOLserver. You will need the tseach2 module form PostgreSQL
+
If you want full text search, and you are running PostgreSQL, install this module to support FTS. Do this step after you have installed both PostgreSQL and
+ AOLserver. You will need the tsearch2 module form PostgreSQL
contrib. This is included with the PostgreSQL full source
distribution. It is also available with the PostgreSQL contrib
package provided by most distribution packages. On debian it is
@@ -18,7 +18,7 @@
tsearch2 from a package, you can use the
http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/regprocedure_update.sql
regprocedure script to update the database after tsearch2 is
- installed into it. TODO link to section decribing how to fix
+ installed into it. TODO link to section describing how to fix
an existing tsearch2 database with this patch.
As of May 9, 2004 there is a source patch available
for
tsearch2. The patch provides changes to the pg_ts_
@@ -105,4 +105,4 @@
new application link.
Click on the Install
link next to Weblogger.
Install all required packages as well (always say okay until you shall restart the server)
Load the service contracts datamodell and enable the service contract
[$OPENACS_SERVICE_NAME $OPENACS_SERVICE_NAME]$ cd packages/lars-blogger/sql/postgresql
[$OPENACS_SERVICE_NAME postgresql]$ psql $OPENACS_SERVICE_NAME -f lars-blogger-sc-create.sql
Note: Usually this script is called package_name-sc-create.sql
Restart the service.
[$OPENACS_SERVICE_NAME postgresql]$ svc -t /service/$OPENACS_SERVICE_NAME
- [$OPENACS_SERVICE_NAME postgresl]$