Welcome Guest | Login

tsearch2 on PostgreSQL

Hi,

I am considering a switch to PostgreSQL from MySQL so that I can use tsearch2 in my rails app and the acts_as_tsearch plug in. This seems to be a simpler route to follow than sphynx or ferret and will hopefully meet my needs.

What's the procedure for setting up tsearch within my database? I tried it myself and got a "permission denied for language c" error. Is this even supported?

Has anyone else here had any experience of tsearch or just running rails apps on PostgreSQL in general?

Martin

2008-07-16 10:01 AM

Hi Martin,

>> What's the procedure for setting up tsearch within my database ?

Please refer the following link which will walk you through setting up tsearch within PostgreSQL database.
http://code.google.com/p/acts-as-tsearch/wiki/PreparingYourPostgreSQLDatabase


>>I tried it myself and got a "permission denied for language c" error.

Could you please update us where exactly you got this error ?




2008-07-16 01:39 PM

HostingRails Support
Roughly step 2 on that PreparingYourPostgreSQLDatabase wiki page.

>psql your_database_name < tsearch2.sql

The tsearch2.sql script creates some functions that reference c libraries.

Martin

2008-07-16 04:14 PM

Hi - I'm sorry, you need root privilege to do this. Please post a ticket to the support team with the database and user name, we will do it for you.

2008-07-16 05:40 PM

HostingRails Support

Hello Guest! In order to post you must be an active client with us, please log in or sign up today!