Trouble connecting Clickhouse to SSL-enabled PostgreSQL Table: How to fix?

[zcoder]

Hello, respected Clickhouse developers and experts!

I've encountered an issue while connecting Clickhouse to a table in PostgreSQL. I use the following query to create the table:

CREATE TABLE if not exists {table_name} as postgresql('127.0.0.1:5432', 'postgres', 'transactions', 'postgres', {PASSWORD});

It works fine!

However, when I try to repeat this process on the production server where SSL connection is required, I receive the following error:

failed: FATAL:  SASL authentication failed
failed: FATAL:  SSL required
. (POSTGRESQL_CONNECTION_FAILURE) (version 23.4.2.11 (official build))

error.log + server.log

Clickhouse is currently running locally in Docker.
I've searched through all the available documentation, reviews, opinions, chatGPT answers, and most of the issues related to this topic, but the answer has eluded me. I haven't found a parameter that would allow using SSL.

I'm turning to you with a request for help with this problem. How do I properly set up an SSL connection to PostgreSQL from Clickhouse?

I want to add that I'm committed to contributing to the Clickhouse community. If a solution is found, I take upon myself the responsibility to ensure it's incorporated into the Clickhouse documentation.

Thank you in advance for any help and recommendations!

[zcoder]

At this point, I suspect that the issue might be linked to the current version of Clickhouse (version 23.4.2.11 (official build)) using an outdated version of the pqxx library, which hasn't been updated in Clickhouse's master branch for the last two years. Interestingly, the library itself has recently added SSL support as seen in this commit.

Could this be a possible lead to the root cause of my issue?