One Star

cannot connect to postgresql Database

Dear Friends,
I tried to connect with localhost postgresql database but i got error as "connection failure".
i am using
Talend open studio Data integration- 5.4.1.r111943
Posgresql DB version - 9.1 x86 (localhost:5432)
I also attached screenshot.
Thanks in advance
with regards,
chandra
10 REPLIES
One Star

Re: cannot connect to postgresql Database

Hi,
Try,
Don't add Database,Schema details.

Thanks,
kumar
One Star

Re: cannot connect to postgresql Database

Hi Kumar,
Still i got the same error, after i left empty for Database and Schema details
with regards,
chandra
One Star

Re: cannot connect to postgresql Database

Hi,
I checked for me it's working fine.No issues
You are enter correct login and password.
Thanks,
kumar.talend
Seventeen Stars

Re: cannot connect to postgresql Database

Please read the error message: "Connection attempt timed out" and therefore the host or the port is wrong nothing else could have an impact at this state.
Six Stars

Re: cannot connect to postgresql Database

Make sure you are accepting TCP/IP connections in your postgresl.conf and your pg_hba.conf. Are you able to connect remotely from another client like pgAdmin or SQuirrel? As mentioned, a timeout means there is no one home at that address/port.
Moderator

Re: cannot connect to postgresql Database

Hi krishnasamy,
Could you connect to your postgresql Database successfully by client without using talend studio?
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.
One Star

Re: cannot connect to postgresql Database

Hi
Could you connect to your postgresql Database successfully by client without using talend studio?
Yes i can connect using PG admin and i can view the database.
my old talend scripts can connect to database and can insert the value.
But if i am Try to create new connection or test the new/ old connection then i get this error.
Thanks and regards
chandra
Moderator

Re: cannot connect to postgresql Database

Hi,
Is there any "X" mark in your postgresql component(missing jar?)
Usually, there are jars required for connection. As soon as you drag the component on the workspace, it would ask to download the particular jar files.
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.
Seventeen Stars

Re: cannot connect to postgresql Database

Hi Sabrina, so far we can say, the driver is loaded because we see an error message made from the driver.
It is definitely a problem caused by the connection parameters.
Sometimes Talend has the bad behaviour to quote context variables and one can overlook it very easely: I mean things like that:
"context.DB_Port"
instead of
context.DB_Port
This happens sometime while importing a job. I had sometime problems with the new password encryption feature which destroys the password also while importing a job.
Probably this is the problem.
Moderator

Re: cannot connect to postgresql Database

Hi jlolling,
Thanks for sharing your experience with us. It is really helpful.
@krishnasamy is there any further process for 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.