SSL issue FATAL: no pg_hba.conf entry for host "my ip", user "me", database "TEST", SSL off

[wzhu]

I encountered an error message "SSL issue FATAL: no pg_hba.conf entry for host "my ip", user "me", database "TEST", SSL off" when tried to load a table from a source postgresql db (version8.x) to a target postgresql db (version 12) using Talend Open Studio for Data integration (version 7.3).

Please note:

A=source db (postgresql v8.x)

B=ETL server (Talend installed, also a test postgresql v12 installed)

C=target db (postgresql v12)

I can run Talend from A to B no problem.

I can run Talend from B to c no problem.

I only encounter error when I run Talend from A to C.

Also, i am able to set DB Connections from B to A and B to C no problem.

[Anonymous]

Hi

As this topic suggested, have you tried to add ssl=true in a additional JDBC parameter.

 

Regards

Shong