I followed this Share Nothing to setup my StarRocks instance, just FE and BE, not CE.
I am trying to add a Postgres DB as a Catalog
CREATE EXTERNAL CATALOG my_pg
PROPERTIES
(
"type"="jdbc",
"user"="postgres",
"password"="postgres",
"jdbc_uri"="jdbc:postgresql://127.0.0.1:5432/my_db",
"driver_url"="https://repo1.maven.org/maven2/org/postgresql/postgresql/42.3.3/postgresql-42.3.3.jar",
"driver_class"="org.postgresql.Driver"
);
It works well until I SELECT something from a table which is about some SSL error.
> show catalogs;
+-----------------+----------+------------------------------------------------------------------+
| Catalog | Type | Comment |
+-----------------+----------+------------------------------------------------------------------+
| my_pg | Jdbc | NULL |
| default_catalog | Internal | An internal catalog contains this cluster's self-managed tables. |
+-----------------+----------+------------------------------------------------------------------+
> set catalog aurora_pg;
> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| pg_catalog |
| public |
+--------------------+
3 rows in set (0.002 sec)
> use public
> show tables;
+----------------------------------------------+
| Tables_in_public |
+----------------------------------------------+
| some_table |
+----------------------------------------------+
> select * from some_table;
ERROR 1064 (HY000): SSL: couldn't create a context: error:140A9041:SSL routines:SSL_CTX_new:malloc failure: BE:10002