Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- nir0@vsluhnew:~/projects/vsluh$ cat /home/nir0/projects/vsluh/config/development.sphinx.conf
- indexer
- {
- }
- searchd
- {
- listen = 127.0.0.1:9312
- log = /home/nir0/projects/vsluh/log/searchd.log
- query_log = /home/nir0/projects/vsluh/log/searchd.query.log
- pid_file = /home/nir0/projects/vsluh/log/searchd.development.pid
- }
- source post_core_0
- {
- type = pgsql
- sql_host = localhost
- sql_user = vsluh
- sql_pass = pgpass
- sql_db = vsluh-dev
- sql_port = 5432
- sql_query_pre = SET TIME ZONE 'UTC'
- sql_query = SELECT "posts"."id" * 1::INT8 + 0 AS "id" , "posts"."name" AS "name", "posts"."text" AS "text", "posts"."author" AS "author", "rubrics"."name" AS "rubric_name", "posts"."id" AS "sphinx_internal_id", 0 AS "sphinx_deleted", 4206412723 AS "class_crc", COALESCE('Post', '') AS "sphinx_internal_class", "posts"."visibility" AS "visibility", cast(extract(epoch from "posts"."published_at") as int) AS "published_at" FROM "posts" LEFT OUTER JOIN "rubrics" ON "rubrics"."id" = "posts"."rubric_id" AND "rubrics"."type" = 'PostRubric' WHERE ("posts"."id" >= $start AND "posts"."id" <= $end) GROUP BY "posts"."id", "posts"."name", "posts"."text", "posts"."author", "rubrics"."name", "posts"."id", "posts"."visibility", "posts"."published_at"
- sql_query_range = SELECT COALESCE(MIN("id"), 1::bigint), COALESCE(MAX("id"), 1::bigint) FROM "posts"
- sql_attr_uint = sphinx_internal_id
- sql_attr_uint = sphinx_deleted
- sql_attr_uint = class_crc
- sql_attr_bool = visibility
- sql_attr_timestamp = published_at
- sql_attr_string = sphinx_internal_class
- sql_query_info = SELECT * FROM "posts" WHERE "id" = (($id - 0) / 1)
- }
- index post_core
- {
- source = post_core_0
- path = /home/nir0/projects/vsluh/db/sphinx/development/post_core
- charset_type = utf-8
- }
- index post
- {
- type = distributed
- local = post_core
- }
Add Comment
Please, Sign In to add comment