Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Manish_Kamble19
Contributor
Contributor

Getting error while passing data from rest api to postgres over an ssh

Can any expert help me to resolve this issue asap.

Exception in component tDBOutput_2 (Test_Agents_forum)

org.postgresql.util.PSQLException: Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.

at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:136)

at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:66)

at org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:125)

at org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:30)

at org.postgresql.jdbc3g.AbstractJdbc3gConnection.<init>(AbstractJdbc3gConnection.java:22)

at org.postgresql.jdbc4.AbstractJdbc4Connection.<init>(AbstractJdbc4Connection.java:30)

at org.postgresql.jdbc4.Jdbc4Connection.<init>(Jdbc4Connection.java:24)

at org.postgresql.Driver.makeConnection(Driver.java:393)

at org.postgresql.Driver.connect(Driver.java:267)

at java.sql.DriverManager.getConnection(Unknown Source)

at java.sql.DriverManager.getConnection(Unknown Source)

at cymetrix.test_agents_forum_0_1.Test_Agents_forum.tREST_1Process(Test_Agents_forum.java:4240)

at cymetrix.test_agents_forum_0_1.Test_Agents_forum.tLoop_1Process(Test_Agents_forum.java:757)

at cymetrix.test_agents_forum_0_1.Test_Agents_forum.tJava_1Process(Test_Agents_forum.java:548)

at cymetrix.test_agents_forum_0_1.Test_Agents_forum.tSshTunnel_1Process(Test_Agents_forum.java:8132)

at cymetrix.test_agents_forum_0_1.Test_Agents_forum.runJobInTOS(Test_Agents_forum.java:8372)

at cymetrix.test_agents_forum_0_1.Test_Agents_forum.main(Test_Agents_forum.java:8216)

Caused by: java.net.ConnectException: Connection timed out: connect

at java.net.DualStackPlainSocketImpl.connect0(Native Method)

at java.net.DualStackPlainSocketImpl.socketConnect(Unknown Source)

at java.net.AbstractPlainSocketImpl.doConnect(Unknown Source)

at java.net.AbstractPlainSocketImpl.connectToAddress(Unknown Source)

at java.net.AbstractPlainSocketImpl.connect(Unknown Source)

at java.net.PlainSocketImpl.connect(Unknown Source)

at java.net.SocksSocketImpl.connect(Unknown Source)

at java.net.Socket.connect(Unknown Source)

at java.net.Socket.connect(Unknown Source)

at java.net.Socket.<init>(Unknown Source)

at java.net.Socket.<init>(Unknown Source)

at org.postgresql.core.PGStream.<init>(PGStream.java:62)

at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:76)

... 16 more

Thanks in advance

Labels (5)
1 Reply
gjeremy1617088143

Hi, as the error say :Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.

You have to check your DB connection.

Send me love and Kudos