postgresql-simple-example

#!/bin/sh


DIR="/cygdrive/C/elasticsearch-jdbc-2.3.4.1/"
bin=${DIR}/../bin
lib=${DIR}/../lib

echo '{
    "type" : "jdbc",
    "jdbc" : {
        "url" : "jdbc:postgresql://localhost:5432/demodb?loglevel=0",
        "user" : "postgres",
        "password" : "abc123",
        "sql" : "select * from srt",
        "index_settings" : {
            "index" : {
                "number_of_shards" : 10
            },
        "elasticsearch" : {
             "cluster" : "elasticsearch",
             "host" : "localhost",
             "port" : 9200
        }
        }
    }
}
' | java \
    -cp "C:\elasticsearch-jdbc-2.3.4.1\lib\*" \
    -Dlog4j.configurationFile="C:\elasticsearch-jdbc-2.3.4.1\bin\log4j2.xml"  org.xbib.tools.Runner  org.xbib.tools.JDBCImporter