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
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.
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
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.
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.