External catalog with postgres

I created an external catalog using postgres as properties .
CREATE EXTERNAL CATALOG jdbc_Catalogue_postgres

I then used the following instructions.

SHOW CATALOGS; to see catalog

SHOW DATABASES FROM jdbc_Catalogue_postgres;

it showed me the different schemas of the database

after i use SET CATALOG jdbc_Catalogue_postgres; to change the default_catalog.

USE jdbc_Catalogue_postgres.public; i use this after

but when i want to select data in the table from public schema
i have this error error setting certificate verify locations: CAfile: /etc/pki/tls/certs/ca-bundle.crt CApath: none

please someone can help me.

Unfortunately we not not experts in postgreSQL, it sounds like there is a problem with TLS

Doing a google search, it seem like there are many options for you to try out. error setting certificate verify locations: CAfile: /etc/pki/tls/certs/ca-bundle.crt CApath: none - Google Search

Another option is to export the data from postgresql and import them into StarRocks. You can export as parquet or CSV or use a tool like Sling Data.

I solved this problem by copying ubuntu’s native certificate into the specified folder with this
sudo mkdir -p /etc/pki/tls/certs
sudo cp /etc/ssl/certs/ca-certificates.crt /etc/pki/tls/certs/ca-bundle.crt