HI, I have a small problem and I do not manage to find solution... Then here, I have a postgresql installed on my computer (computer A) under linux. I would like to connect me to this base since another computer Windows 7pro (computer B) using talend, on the same network as computer A. For that, I started by modifying the files (on computer A) postgresql.conf: listen_address = ' * ' pg_hba.conf: host all postgres 192.168.10.(ip of my computer B)/24 trust To connect it self in talend I make like this: userostgres password:***** server:192.168.10.(ip computerA) port:5432 DB:db_name And i have this error:failure of connection you must modify the parameters of the data base Failure of connection You must modify the parameters of the data base. org.postgresql.util.PSQLException: Refused connection. Check that the name of machine and the port are correct and that postmaster accepts connections TCP/IP. can you help me please!!!
Hi, Can you successfully ping/telnet computer A from Windows 7pro (computer B)? Are your postgresql DB connection parameter(user, password, port...) correct for you? Can you connect to postgresql DB through client without using Talend Tool? 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 thank you for your reply, yes I can make ping/telnet to computer A from Windows 7pro it walks very well, yes I believe that the parameter of connection of my DB is correct. No i can't connect to postgresql DB through client without using Talend Tool. Thanks In Advance , Laetty
Hi, I forgot to tell you in the begining that the DB postgresql is on a linux server. I try to connect on it with PUTTY SSH then i can connect successfully with the DB using the same parameters that i use on talend and i can access on the tables on the DB. So i tried to connect with another ETL tool but i have the same error. I am really at court of idea, without being able connected to the DB I can'nt begun my project, anyone could help me please !!! Thanks In Advance , Laetty
laetty, Consider adding an entry in ipconfig file for activating port no - 5432. This will help in accepting connections on this port no from remote computers. Please explore on HOW-TO edit ipconfig configurations.