External catalog with postgres

Infrastructure and Operations Shared Data Architecture
1

I created an external catalog using postgres as properties .
CREATE EXTERNAL CATALOG jdbc_Catalogue_postgres
PROPERTIES (
“type”=“jdbc”,
“user”=“postgres”,
“password”=“password”,
“jdbc_uri”=“jdbc:postgresql://127.1.1.1:5432/database”,
“driver_url”=“https://repo1.maven.org/maven2/org/postgresql/postgresql/42.3.3/postgresql-42.3.3.jar”,
“driver_class”=“org.postgresql.Driver”
);

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.

2

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.

3

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