Is it possible to use Sphinx with Postgres?

edit

I need configure something for search's in Askbot work with Postgres FTS?

No, the configuration for that is built in. If you run migrations FTS will be set up. There is also a management command init_postgresql_full_text_search. If you are bypassing migrations with syncdb --all, then run that command afterwards. The command can be run many times without any issues.

How do I run this management command?

python manage.py command_name

./manage.py init_postgres_full_text_search This command does't run.

edited my comment - there was typo in the name. all askbot's management commands are listed in the documentation.

What typo error? I don't find this command in documentation page. When I try run above command i get this message: Unknown command: 'init_postgres_full_text_search'

I find typing ./manage.py --help (the correctly command is: init_postgresql_full_text_search)

yes, that's it.

I have problems with search yet. I have a word "problema" within a question. If I search for this word the system no returns nothing. Do you have any ideia how I can resolve this issue?

Probably because english language is hardcoded, open file askbot/search/postgresql/thread_and_post_models_05222012.plsql and change 'english' to whatever suits you, then rerun the command to refresh the search config and try searching again.

If I change this the internal queries of Askbot run correctely?

They will, as long as the language setting is correct. I've tried this with Russian and it worked.

I change ts_vector('english') to ts_vector('portuguese'). Then I run "./manage.py init_postgresql_full_text_search". Nothing changes in search.

http://stackoverflow.com/questions/3935941/cannot-get-right-results-from-postgre-full-text-search found this, maybe it will help. I don't know how postgres supports Portugese or how to set it up.

It works, now. I change manualy the functions in Postgres. The management command don't update the functions.

Might be useful to compare search engines on a text dump before coding the search backend. This would also be a cool blog post that would get good traffic, to promote askbot.

@Evgeny: Can you provide an indication on when the Haystack code would be added to master? Waiting on this eagerly.