Thread:Extension talk:SphinxSearch/sphinx.conf for postgresql

Here's a sphinx.conf with SQL queries suitable for postgresql. I run these on mediawiki 0.21.2 installations running the latest extension and Sphinx 2.1.2, but it will probably work just fine with older versions.

The key differences are:


 * A different syntax for specifying UTF-8 character encoding. Probably unecessary, but it doesn't hurt.
 * The need to put 'mediawiki' in the schema search path to avoid scoping all the tables
 * Under postgresql (and Oracle) the 'text' table is called 'pagecontent'
 * The query in sql_attr_multi doesn't have the sql_pre_query run before it, so we have to scope the tables to the 'mediawiki' schema explicitly
 * The syntax for building an appropriate cut off date in the incremental section is in the postgresql form

Here are the relevant bits: