First time here? Check out the FAQ!
2

Is it possible to use Sphinx with Postgres?

Is it possible to use Sphinx with Postgres?

Erick Almeida's avatar
73
Erick Almeida
asked 2012-07-12 13:30:30 -0600
todofixthis's avatar
1.3k
todofixthis
updated 2012-07-12 17:01:04 -0600
edit flag offensive 0 remove flag close merge delete

Comments

add a comment see more comments

1 Answer

2

Not as it is coded now. Is Sphinx search better than Postgres FTS?

We are adding support of Haystack soon, already have the code on one of the development branches.

Evgeny's avatar
13.2k
Evgeny
answered 2012-07-12 13:37:17 -0600
edit flag offensive 0 remove flag delete link

Comments

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

Erick Almeida's avatar Erick Almeida (2012-07-12 13:42:46 -0600) edit

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.

Evgeny's avatar Evgeny (2012-07-12 13:47:31 -0600) edit

How do I run this management command?

Erick Almeida's avatar Erick Almeida (2012-07-12 13:50:22 -0600) edit

python manage.py command_name

Evgeny's avatar Evgeny (2012-07-12 13:51:00 -0600) edit

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

Erick Almeida's avatar Erick Almeida (2012-07-12 13:57:50 -0600) edit

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

Evgeny's avatar Evgeny (2012-07-12 13:59:31 -0600) edit

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'

Erick Almeida's avatar Erick Almeida (2012-07-12 14:30:07 -0600) edit

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

Erick Almeida's avatar Erick Almeida (2012-07-12 14:31:35 -0600) edit
add a comment see more comments