Linux installation postgres full-text Search support

Statement:

Postgres-version 9.2.5

* Specific installation methods refer to the following link:

1. http://blog.scimpr.com/2014/08/11/ubuntu12-04%E3%81%A7postgresql%E3%81%AE%E5%85%A8%E6%96%87%E6%A4%9C%E7%B4% a2%e3%80%9ctextsearch_ja/

* Summary of problems encountered during installation:

1. The "Make use_pgxs=1" Command error occurred when the link operation was performed

Tip: "Pgxs.mk File not found" error, reason, missing reference rpm package.

Execution: Yum Install postgres-devel-9.25-1.fc18.x86_64.rpm

2. Continue to execute the command error,

Tip: The "mecab" file cannot be found.

Execution: Yum Install mecab-devel.x86-64

3. Toggle Postgres User , perform to this step psql -f /usr/ share/postgresql/< Span class= "CRAYON-CN" >9.1/contrib/textsearch_ja. In SQL time, enter continues to error.

< Span class= "crayon-h" > < Span class= "crayon-v" > hint: There is no built-in function named "$libdir/textsearch_ja".  

< Span class= "crayon-h" > < Span class= "crayon-v" > cause , open this textsearch_ja.sql file to find [  LANGUAGE ' C ' STRICT; ] to overwrite all C in the bold part of the current file in single quotation marks to lowercase c.

< Span class= "crayon-h" > < Span class= "crayon-v" > 4. Following Continued execution, order interpretation.

< Span class= "crayon-h" > < Span class= "crayon-v" > Strong>a .  create INDEX idx on test USING Gin (to_tsvector (' Japanese ', name );

< Span class= "crayon-h" > < Span class= "crayon-v" > solution Explanation: Test: Database table name

< Span class= "crayon-h" > < Span class= "crayon-v" >　　　　　　   Japanese: Japanese encoding

< Span class= "crayon-h" > < Span class= "crayon-v" >　　　　　　   Name: Database table column name

< Span class= "crayon-h" > < Span class= "crayon-v" > Strong>b .  select * FROM Test WHERE to_tsvector (' Japanese ', name) @@ to_tsquery (' Japanese ', Web_query (' strong> ')

< Span class= "crayon-h" > < Span class= "crayon-v" > 5. According to the installation process encountered special problems, can leave a message, discuss together.

　　

Linux installation postgres full-text Search support