PostgresQL - SSL connectivity issue

[Anonymous]

I have a job that makes use of ELT components in which I try to connect to a Postgres database in Azure.

It's giving me a 'no pg_hba.conf' error. I ensured that my IP address was whitelisted and reading the debug error further "org.postgresql.util.PSQLException: FATAL: no pg_hba.conf entry for host "174.112.236.230", user "citus", database "citus", SSL off", it appears that SSL is off.

How can I enable SSL in the connection settings for Postgres (see screenshot)?

Roland

[Anonymous · Accepted solution]

Did you tried to set a additional JDBC parameter: 

ssl=true

in the advanced settings of the connection component?

Checkout further information here: https://jdbc.postgresql.org/documentation/head/ssl-client.html

[Anonymous]

Did you tried to set a additional JDBC parameter: 

ssl=true

in the advanced settings of the connection component?

Checkout further information here: https://jdbc.postgresql.org/documentation/head/ssl-client.html

[Anonymous]

Yes, thank you! I've been on this issue for quite a while today and this is actually working!

[Anonymous]

Yes, thank you! I've been on this issue for quite a while today and this is actually working!

[wzhu]

Hi,

Could you share how to set ssl=true in the advanced settings of the connection component ? i am using Talend Open Studio 7.3

Many thanks!

David

[wzhu]

Hi dev323,

I am glad your issue was resolved. i am encountering the similar issue now...could you share how to set ssl=true in the advanced settings of the connection component ? i am using Talend Open Studio 7.3.

Screenshots would be much helpful!

Many thanks!

David