# Sample Logstash configuration for creating a simple
# Beats -> Logstash -> Elasticsearch pipeline.

input {
  jdbc {
    #jdbc_driver_library => "/usr/share/logstash/logstash-core/lib/jars/postgresql-42.2.8.jar"
    jdbc_driver_class => "org.postgresql.Driver"
    jdbc_connection_string => "jdbc:postgresql://x.y.z.t:5432/bd"
    jdbc_user => "xyz"
    jdbc_password => "xyz"
    schedule => "20 * * * *"
    statement => "SELECT * from organization_organization"
    #jdbc_validate_connection => true
    #use_column_value => true
    #tracking_column => "id"
  }
}


output {
  elasticsearch {
    hosts => ["http://1.1.1.10:9200"]
    index => "organization_teste"
    document_id => "%{id}"
    document_type => "organizacao"
   }
 }