topic Re: org.postgresql.util.PSQLException: Connection to server:port refused. in Talend Studio

org.postgresql.util.PSQLException: Connection to server:port refused.

Anonymous — Sat, 16 Nov 2024 10:27:22 GMT

I am getting below error intermittently in Spark job which loads data from one hawq table into another.
org.postgresql.util.PSQLException: Connection to ServerName:7432 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
Caused by: java.net.ConnectException: Connection timed out: connect
We have another utility written in java which also does the same, but this error has not appeared even once. We have been using the same jdbc driver and same connection details.
The same job has been executed successfully with same configuration couple of times. We tested the job with both dns name and ip address in the db configuration.
The pg_hba.conf file has been verified and are correct, the "TRUST" access has been given.
Appreciate your help in providing some pointers.
System Details-

To see the whole post, download it here

Re: org.postgresql.util.PSQLException: Connection to server:port refused.

Anonymous — Thu, 18 Aug 2016 08:18:26 GMT

Hi,
Could you please post your spark job setting screenshots into forum which will be helpful for us to address your issue?
Best regards
Sabrina

Re: org.postgresql.util.PSQLException: Connection to server:port refused.

Anonymous — Mon, 22 Aug 2016 10:43:21 GMT

Attached the snapshots below - Please let me know if you need more information.
There is one more observation that in tJDBCConfiguration component, for property type "Repository" the DB Connections which have been created in "Metadata" are not appearing. The last two snapshot are related to those.

Re: org.postgresql.util.PSQLException: Connection to server:port refused.

Anonymous — Mon, 22 Aug 2016 10:54:34 GMT

Attached the snapshots

Re: org.postgresql.util.PSQLException: Connection to server:port refused.

Anonymous — Wed, 24 Aug 2016 05:47:28 GMT

Looks like the images are not getting uploaded. Is there any alternative to share the requested details.

Re: org.postgresql.util.PSQLException: Connection to server:port refused.

Anonymous — Wed, 24 Aug 2016 09:33:51 GMT

Hi,
Screenshots works only if you drag&drop the image directly in the editor window.
Best regards
Sabrina