logstash-2.conf

input {
  jdbc {
     jdbc_connection_string => "jdbc:postgresql://fda-metadata-db:5432/fda"
     jdbc_user => "postgres"
     jdbc_password => "postgres"
     jdbc_driver_class => "org.postgresql.Driver"
     jdbc_driver_library => "/usr/share/logstash/postgresql.jar"
     statement => "SELECT  cdbid, tid, cid, maxlength, last_modified, created from mdb_columns_nom;"
     schedule => "*/1 * * * *"
 }
}
output {
      stdout { }
    }
output {
  elasticsearch {
    hosts => ["http://fda-search-service:9200"]
    index => "columnstypeindex"
    document_id => "%{cdbid}.%{tid}.%{cid}"
    doc_as_upsert => true
    #user => "es_user"
    password => "elastic"
 }
}