I am using logstash 7.14 and the jdbc plugin with the following settings
jdbc {
type => "jdbc-audit"
id => "dev-jdbc-audit"
jdbc_driver_library => "/opt/appl/lib/postgresql-42.5.1.jar"
jdbc_driver_class => "org.postgresql.Driver"
jdbc_connection_string => "jdbc:postgresql://test.com:5432/dev"
jdbc_user => "dev"
jdbc_password => "pass"
jdbc_fetch_size => 100000
jdbc_page_size => 200000
jdbc_paging_enabled => true
tracking_column => "entity_timestamp"
tracking_column_type => "timestamp"
use_column_value => true
schedule => "* * * * *"
statement => 'SELECT * from "AO_C77861_AUDIT_ENTITY"'
}
The file .logstash_jdbc_last_run file is never created.
It should be created by default according to the documentation.
I find no permission denied errors or any mention of a *last_run file anywhere on the server.