0

I have a AWS ec2 instance running Bitnami OSQA stack(using postgresql), to implement the full text search, I have tried on my develop server(original OSQA with mysql).

The problem is, when I add mysqlfulltext in disable session in Settings_local.py, I can success in my develop server, while in production server AWS EC2 doesn't work, I know there should be some engine for postgresql, but don't know the name.

Anyone know this?

--add in the part of OSQA settings_local.py, there is a session as below DISABLED_MODULES = ['books', 'recaptcha', 'project_badges','mysqlfulltext'],it works fine in my developserver with mysql, but for product develop server in postgresql, I tries to use pgsqlfulltext instead but failed for searching.

user2661024
  • 1
  • 1
  • 1
    Not sure what you mean by "fulltext engine", but [PostgreSQL supports fulltext by default](http://www.postgresql.org/docs/9.2/static/textsearch-intro.html) – RandomSeed Aug 07 '13 at 14:05
  • in the part of OSQA settings_local.py, there is a session as below DISABLED_MODULES = ['books', 'recaptcha', 'project_badges','mysqlfulltext'],it works fine in my developserver with mysql, but for product develop server in postgresql, I tries to use pgsqlfulltext instead but failed for searching. – user2661024 Aug 07 '13 at 14:10
  • Oh you are asking about the name of OSQA module to enable in order to leverage the fulltext feature of PostgreSQL. Sorry, I have no clue about OSQA ;) – RandomSeed Aug 07 '13 at 14:19
  • Correct, so waiting for anyone know it. – user2661024 Aug 07 '13 at 14:21
  • I found [this Q&A](http://meta.osqa.net/questions/3945/search-broken-running-against-postgresql). It is a bit outdated; but it might prove useful. – RandomSeed Aug 07 '13 at 14:24
  • Cheers,success finally by pgfulltext instead of mysqlfulltext. Thanks, have a great day ahead. – user2661024 Aug 07 '13 at 14:44

1 Answers1

1

Here is the relevant manual page.

It refers to a module called "pgfulltext".

RandomSeed
  • 29,301
  • 6
  • 52
  • 87