topic Re: PostgresQL - SSL connectivity issue in Talend Studio

PostgresQL - SSL connectivity issue

Anonymous — Thu, 09 Jul 2020 18:31:11 GMT

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

Re: PostgresQL - SSL connectivity issue

Anonymous — Thu, 09 Jul 2020 19:14:37 GMT

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

Re: PostgresQL - SSL connectivity issue

Anonymous — Thu, 09 Jul 2020 19:14:37 GMT

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

Re: PostgresQL - SSL connectivity issue

Anonymous — Thu, 09 Jul 2020 20:05:44 GMT

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

Re: PostgresQL - SSL connectivity issue

Anonymous — Thu, 09 Jul 2020 20:05:44 GMT

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

Re: PostgresQL - SSL connectivity issue

wzhu — Mon, 10 May 2021 19:15:50 GMT

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

Re: PostgresQL - SSL connectivity issue

wzhu — Mon, 10 May 2021 19:18:43 GMT

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