4
by Evan Dandrea
Added sphinx configuration. |
1 |
source geonamessrc |
2 |
{
|
|
3 |
type = pgsql |
|
4 |
sql_host = localhost |
|
5 |
sql_user = geouser |
|
6 |
sql_pass = geopw |
|
7 |
sql_db = geonames |
|
14.1.1
by Michael Terry
search alternatename database too |
8 |
sql_query = SELECT geoname.geonameid*10+1 AS id, geoname.name AS name, geoname.population AS population, geoname.geonameid AS geonameid FROM geoname WHERE geoname.fclass='P' |
9 |
sql_attr_uint = population |
|
10 |
}
|
|
11 |
||
12 |
source altnamessrc |
|
13 |
{
|
|
14 |
type = pgsql |
|
15 |
sql_host = localhost |
|
16 |
sql_user = geouser |
|
17 |
sql_pass = geopw |
|
18 |
sql_db = geonames |
|
19 |
sql_query = SELECT alternatename.alternatenameId*10+2 AS id, alternatename.alternateName AS name, geoname.population AS population, geoname.geonameid AS geonameid FROM alternatename JOIN geoname on (geoname.geonameid = alternatename.geonameid AND geoname.name != alternatename.alternateName) WHERE (geoname.fclass='P' AND (LENGTH(alternatename.isoLanguage) < 4 OR alternatename.isoLanguage is null)) |
|
12.1.1
by Michael Terry
sort by population |
20 |
sql_attr_uint = population |
4
by Evan Dandrea
Added sphinx configuration. |
21 |
}
|
22 |
||
23 |
index geonames |
|
24 |
{
|
|
25 |
source = geonamessrc |
|
14.1.1
by Michael Terry
search alternatename database too |
26 |
source = altnamessrc |
4
by Evan Dandrea
Added sphinx configuration. |
27 |
path = /var/lib/sphinxsearch/data/geonames |
28 |
docinfo = extern |
|
29 |
morphology = none |
|
30 |
stopwords = |
|
31 |
min_word_len = 2 |
|
32 |
min_prefix_len = 0 |
|
33 |
min_infix_len = 0 |
|
14.1.3
by Karl Lattimer
Working utf8 |
34 |
charset_type = utf-8 |
14.1.5
by Karl Lattimer
stray i |
35 |
charset_table = U+FF10..U+FF19->0..9, 0..9, U+FF41..U+FF5A->a..z, U+FF21..U+FF3A->a..z,A..Z->a..z, a..z, U+0149, U+017F, U+0138, U+00DF, U+00FF, U+00C0..U+00D6->U+00E0..U+00F6,U+00E0..U+00F6, U+00D8..U+00DE->U+00F8..U+00FE, U+00F8..U+00FE, U+0100->U+0101, U+0101, U+0102->U+0103, U+0103, U+0104->U+0105, U+0105, U+0106->U+0107, U+0107, U+0108->U+0109, U+0109, U+010A->U+010B, U+010B, U+010C->U+010D, U+010D, U+010E->U+010F, U+010F, U+0110->U+0111, U+0111, U+0112->U+0113, U+0113, U+0114->U+0115, U+0115, U+0116->U+0117, U+0117, U+0118->U+0119, U+0119, U+011A->U+011B, U+011B, U+011C->U+011D, U+011D, U+011E->U+011F, U+011F, U+0130->U+0131, U+0131, U+0132->U+0133, U+0133, U+0134->U+0135, U+0135, U+0136->U+0137, U+0137, U+0139->U+013A, U+013A, U+013B->U+013C, U+013C, U+013D->U+013E, U+013E, U+013F->U+0140, U+0140, U+0141->U+0142, U+0142, U+0143->U+0144, U+0144, U+0145->U+0146, U+0146, U+0147->U+0148, U+0148, U+014A->U+014B, U+014B, U+014C->U+014D, U+014D, U+014E->U+014F, U+014F, U+0150->U+0151, U+0151, U+0152->U+0153, U+0153, U+0154->U+0155, U+0155, U+0156->U+0157, U+0157, U+0158->U+0159, U+0159, U+015A->U+015B, U+015B, U+015C->U+015D, U+015D, U+015E->U+015F, U+015F, U+0160->U+0161, U+0161, U+0162->U+0163, U+0163, U+0164->U+0165, U+0165, U+0166->U+0167, U+0167, U+0168->U+0169, U+0169, U+016A->U+016B, U+016B, U+016C->U+016D, U+016D, U+016E->U+016F, U+016F, U+0170->U+0171, U+0171, U+0172->U+0173, U+0173, U+0174->U+0175, U+0175, U+0176->U+0177, U+0177, U+0178->U+00FF, U+00FF, U+0179->U+017A, U+017A, U+017B->U+017C, U+017C, U+017D->U+017E, U+017E, U+4E00..U+9FFF, U+3000..U+30FF |
4
by Evan Dandrea
Added sphinx configuration. |
36 |
}
|
37 |
searchd
|
|
38 |
{
|
|
39 |
port = 3312 |
|
40 |
log = /var/log/sphinxsearch/searchd.log |
|
41 |
query_log = /var/log/sphinxsearch/query.log |
|
42 |
read_timeout = 5 |
|
43 |
max_children = 30 |
|
18
by Dmitrijs Ledkovs
* Update README (mention python-psycopg2 dependency) |
44 |
pid_file = /var/run/searchd.pid |
4
by Evan Dandrea
Added sphinx configuration. |
45 |
max_matches = 1000 |
46 |
seamless_rotate = 1 |
|
47 |
preopen_indexes = 0 |
|
48 |
unlink_old = 1 |
|
49 |
}
|