cannot connect to postgresql Database

[Anonymous]

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

[Anonymous]

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

Thanks,
kumar

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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.

[Anonymous]

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.

[Anonymous]

Hi krishnasamy,
Could you connect to your postgresql Database successfully by client without using talend studio?
Best regards
Sabrina

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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.