Solr4.7.0连接PostgreSQL

1.把PostgreSQL的Jar包  例如：postgresql-9.1-901-1.jdbc4.jar  或其他版本

　　放到D:\apache-tomcat-7.0.57\webapps\solr\WEB-INF\lib下

2.然后在tomcat-solr\collection1\conf下新建一个配置文件：data-config.xml,然后在本目录下编辑配置文件:solrconfig.xml

　　找到很多个requestHandler节点，在最下面增加：

<requestHandler name="/dataimport" class="org.apache.solr.handler.dataimport.DataImportHandler">
        <lst name="defaults">
            <str name="config">data-config.xml</str>
        </lst>
    </requestHandler>
或
　　
　　<requestHandler name="/dataimport" class="org.apache.solr.handler.dataimport.DataImportHandler"> 
    　　<lst name="defaults"> 
          　　<str name="config">D:\apache-tomcat-7.0.57\webapps\solr\solr_home\collection1\conf\data-config.xml</str> 
    　　</lst> 
　　</requestHandler>

3. 将初次下载的solr-4.10.2文件夹下的dist, contrib文件夹复制到TomCat根目录下：

　　

4.然后再次修改刚才编辑过的solrconfig.xml增加两个文件夹的配置并修改一些参数：

　　大约在75行默认有8个路径，但是路径不一定全对，顺着这个配置的路径去找文件夹，根据查找的层数修改这个路径配置，另增加一个新的配置，全文如下：(具体配置还要根据实际情况而定)

  <lib dir="D:\apache-tomcat\contrib\extraction\lib" regex=".*\.jar" />

  <lib dir="D:\apache-tomcat\dist\" regex="solr-cell-\d.*\.jar" />

  <lib dir="D:\apache-tomcat\contrib\clustering\lib\" regex=".*\.jar" />

  <lib dir="D:\apache-tomcat\dist\" regex="solr-clustering-\d.*\.jar" />

  <lib dir="D:\apache-tomcat\contrib\langid\lib\" regex=".*\.jar" />

  <lib dir="D:\apache-tomcat\dist\" regex="solr-langid-\d.*\.jar" />

  <lib dir="D:\apache-tomcat\contrib\velocity\lib" regex=".*\.jar" />

  <lib dir="D:\apache-tomcat\dist\" regex="solr-velocity-\d.*\.jar" />

  <lib dir="D:\apache-tomcat\dist\" regex="solr-dataimporthandler-\d.*\.jar" />

5. 将dist文件夹下的

　　

　　复制到webapps\solr\WEB-INF\lib下。

6.编辑data-config.xml,例如

<!-- db导入solr配置文件 -->
<dataConfig>
    <dataSource driver="org.postgresql.Driver"
                url="jdbc:postgresql://localhost:5432/postgres?useUnicode=true&amp;characterEncoding=utf-8"
                user="postgres" password="000000"/>
    <document>
        <entity name="notification" pk="ID" query="SELECT
            'SLQ_Notification' AS type,
            &quot;NOTIFY_ID&quot; AS indexId,
            &quot;UUID&quot; AS uuid,
            &quot;NOTIFY_ID&quot; AS notifyId,
            &quot;NOTIFY_TYPE&quot; AS notifyType,
            &quot;DIRECTION&quot; AS direction,
            &quot;UID&quot; AS uid,
            &quot;MSG&quot; AS msg,
            &quot;REF_ID&quot; AS refId,
            &quot;REF_UID&quot; AS refUid,
            &quot;APPLY_UID&quot; AS applyUid,
            &quot;APPLY_ID&quot; AS applyId,
            &quot;REF_IMAGE_URLS&quot; AS refImageUrls,
            &quot;FROM_UID&quot; AS fromUid,
            &quot;LAST_UPDATE_TIME&quot; AS lastUpdateTime,
            &quot;CREATE_TIME&quot; AS createTime,
            &quot;IS_DELETED&quot; AS isDeleted
            FROM &quot;TBL_SLQ_NOTIFICATION&quot;"/>

        <entity name="letter" pk="ID" query="SELECT
            'SLQ_Letter' AS type,
            'slq'||&quot;ID&quot; AS indexId,
            &quot;DIRECTION&quot; AS direction,
            &quot;MSG_BOX_TYPE&quot; AS messageBoxType,
            &quot;UUID&quot; AS uuid,
            &quot;MSG_TYPE&quot; AS msgType,
            &quot;DURATION&quot; AS duration,
            &quot;CONTENT&quot; AS msg,
            &quot;AUDIO_URLS&quot; AS audioUrls,
            &quot;VIDEO_URLS&quot; AS videoUrls,
            &quot;IMAGE_URLS&quot; AS imageUrls,
            &quot;TO_UID&quot; AS toUid,
            &quot;REF_ID&quot; AS refId,
            &quot;REF_UID&quot; AS refUid,
            &quot;APPLY_UID&quot; AS applyUid,
            &quot;SUGGEST_UID&quot; AS suggestUid,
            &quot;FROM_UID&quot; AS fromUid,
            &quot;CREATE_TIME&quot; AS createTime,
            &quot;IS_DELETED&quot; AS isDeleted
         FROM &quot;TBL_SLQ_MESSAGE&quot;"/>
    </document>
</dataConfig>

7.编辑schema.xml文件   和mysql oracle一样