search

theangryangel / logstash-output-jdbc

JDBC output for Logstash
MIT License
256 stars 101 forks source link

org.postgresql.util.PSQLException: ERROR: relation "my_table_name" does not exist #126

Closed shoaibjdev closed 6 years ago

shoaibjdev commented 6 years ago

logstash-6.2.2 Postgre JDBC Jar: postgresql-42.1.4.jre7.jar

Have created the table and able to connect from other JDBC applications. But for logstash-output-jdbc getting this error

org.postgresql.util.PSQLException: ERROR: relation "my_table_name" does not exist

theangryangel commented 6 years ago

The error is from PostgreSQL and tells you the table doesn’t exist.

Either you’ve configured the plugin with the wrong details (I.e an account that doesn’t have access, etc) or you’ve typoed the table. This isn’t an issue with the plugin itself and is entirely down to your environment/setup. It is virtually impossible for me to help further.

Edit; there are test cases for Postgres so I know it works fine, and there are examples in the repo. If you really need help I need the name of the table, and the exact config you’re using. Providing redacted ones probably won’t help if you’ve spelt it incorrectly and then remove it.