Four Stars

PostgreSQL connection error

Hi All / Team,

 

I am getting below error while i am trying to connect to Heroku PostgreSQL. Request you to kindly help me.

 

Connection details:

 

DB Type : PostgreSQL

DB Verson : Prior to v9 or any

Host : ec2-54-75-224-100.eu-west-1.compute.amazonaws.com

Database : d47os107p1ek80

Login : geznadgmngwblo

Port : 5432

Password : 40b1f6233cd25b3acef5b27185919683894692e8895fa8a7b4d7bfd5d8de6f66

Schema : salesforcennikumdevorg

 

Error:

 

Connection failure. You must change the Database Settings.
java.lang.RuntimeException: org.postgresql.util.PSQLException: Connection attempt timed out.
at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getConnection(JDBCDriverLoader.java:195)
at org.talend.core.model.metadata.builder.database.ExtractMetaDataUtils.connect(ExtractMetaDataUtils.java:1095)
at org.talend.core.model.metadata.builder.database.ExtractMetaDataFromDataBase.testConnection(ExtractMetaDataFromDataBase.java:315)
at org.talend.metadata.managment.repository.ManagerConnection.check(ManagerConnection.java:289)
at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm$62.runWithCancel(DatabaseForm.java:3983)
at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm$62.runWithCancel(DatabaseForm.java:1)
at org.talend.repository.ui.dialog.AProgressMonitorDialogWithCancel$1.runnableWithCancel(AProgressMonitorDialogWithCancel.java:77)
at org.talend.repository.ui.dialog.AProgressMonitorDialogWithCancel$ARunnableWithProgressCancel$1.call(AProgressMonitorDialogWithCancel.java:161)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)

Caused by: org.postgresql.util.PSQLException: Connection attempt timed out.
at org.postgresql.Driver$ConnectThread.getResult(Driver.java:352)
at org.postgresql.Driver.connect(Driver.java:264)
at org.talend.core.model.metadata.builder.database.DriverShim.connect(DriverShim.java:41)
at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getConnection(JDBCDriverLoader.java:186)
... 9 more

 

Thank you,

Narendra Nikum

+91 9731271416

4 REPLIES
Moderator

Re: PostgreSQL connection error

Hello,

 

With your DB connection parameters, could you successfully connect to PostgreSQL DB directly by client without talend tool?

Have you already downloaded and installed required jar files in talend studio for PostgreSQL connection?

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Four Stars

Re: PostgreSQL connection error

Hi Sabrina,

 

Thank you so much for your mail, PFB new connection details. i have created new PostgreSQL DB in Heroku. Hope it helps, because using heroku i am able to connect to this PostgreSQL database.

 

Host: ec2-54-163-254-143.compute-1.amazonaws.com

Port : 5432

Database : d21gmbnlr6hi6s

schema : salesforce

User : npdulhqsumdyhv

Password : c0130dd662e703254a654978fb375450598973ce2af91c652836c20195c64599

URI : postgres://npdulhqsumdyhv:c0130dd662e703254a654978fb375450598973ce2af91c652836c20195c64599@ec2-54-163-254-143.compute-1.amazonaws.com:5432/d21gmbnlr6hi6s

Heroku CLI : heroku pgSmiley Tonguesql postgresql-curved-11352 --app nikumtestapp1

 

Thank you,

Narendra Nikum

9731271416

Four Stars

Re: PostgreSQL connection error

Hi Sabrina,

 

When i am trying in my home network i am getting below error. Kindly help me.

 

Host: ec2-54-163-254-143.compute-1.amazonaws.com

Port : 5432

Database : d21gmbnlr6hi6s

schema : salesforce

User : npdulhqsumdyhv

Password : c0130dd662e703254a654978fb375450598973ce2af91c652836c20195c64599

URI : postgres://npdulhqsumdyhv:c0130dd662e703254a654978fb375450598973ce2af91c652836c20195c64599@ec2-54-163-254-143.compute-1.amazonaws.com:5432/d21gmbnlr6hi6s

Heroku CLI : heroku pgSmiley Tonguesql postgresql-curved-11352 --app nikumtestapp1

 

Connection failure. You must change the Database Settings.
java.lang.RuntimeException: org.postgresql.util.PSQLException: FATAL: no pg_hba.conf entry for host "157.49.1.67", user "npdulhqsumdyhv", database "d21gmbnlr6hi6s", SSL off
at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getConnection(JDBCDriverLoader.java:195)
at org.talend.core.model.metadata.builder.database.ExtractMetaDataUtils.connect(ExtractMetaDataUtils.java:1095)
at org.talend.core.model.metadata.builder.database.ExtractMetaDataFromDataBase.testConnection(ExtractMetaDataFromDataBase.java:315)
at org.talend.metadata.managment.repository.ManagerConnection.check(ManagerConnection.java:289)
at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm$62.runWithCancel(DatabaseForm.java:3983)
at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm$62.runWithCancel(DatabaseForm.java:1)
at org.talend.repository.ui.dialog.AProgressMonitorDialogWithCancel$1.runnableWithCancel(AProgressMonitorDialogWithCancel.java:77)
at org.talend.repository.ui.dialog.AProgressMonitorDialogWithCancel$ARunnableWithProgressCancel$1.call(AProgressMonitorDialogWithCancel.java:161)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Caused by: org.postgresql.util.PSQLException: FATAL: no pg_hba.conf entry for host "157.49.1.67", user "npdulhqsumdyhv", database "d21gmbnlr6hi6s", SSL off
at org.postgresql.Driver$ConnectThread.getResult(Driver.java:341)
at org.postgresql.Driver.connect(Driver.java:264)
at org.talend.core.model.metadata.builder.database.DriverShim.connect(DriverShim.java:41)
at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getConnection(JDBCDriverLoader.java:186)
... 9 more

 

 

Thank you,

Narenndra Nikum

9731271416

Moderator

Re: PostgreSQL connection error

Hello,

Could you please have a look at this article:https://stackoverflow.com/questions/16740095/org-postgresql-util-psqlexception-fatal-no-pg-hba-conf-... to see if it is OK with your issue?

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.