JDBC through a SSH tunnel

Im getting data from a PostgreSQL DB through an SSH tunnel:

autossh -M 0 -o "ServerAliveInterval 30" -o "ServerAliveCountMax 3" -L 9999:localhost:5432 root@mypostgresip

The data is requested using Logstash JDBC pointing to localhost:

jdbc_connection_string => "jdbc:postgresql://"

The JDBC query runs every 2 minutes

The problem that I have is that the data transmition only last for a little while, then the last_value get stuck and never advances. The connection is alive, but no data is coming through.

any ideas on what is going on?

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.