版本:postgresql-16.3-1,Doris2.1.0
CREATE CATALOG jdbc_postgresql_test PROPERTIES (
"type"="jdbc",
"user"="postgres",
"password"="postgres",
"jdbc_url" = "jdbc:postgresql://10.0.20.252:5432/test",
"driver_url" = "file:///opt/soft/doris/apache-doris-2.1.0-bin-arm64/postgresql-42.7.3.jar",
"driver_class" = "org.postgresql.Driver",
"connection_pool_min_size" = "1",
"connection_pool_max_size" = "10"
);
创建完成后使用show databases from jdbc_postgresql_test;
出现报错提示:
ERROR 1105 (HY000): Can not connect to jdbc due to error: com.alibaba.druid.pool.GetConnectionTimeoutException: wait millis 5000, active 0, maxActive 10, creating 0, createErrorCount 58, Catalog name: jdbc_postgresql_test
IP和端口是通的,用其他机器上的postgresql客户端是可以连接到数据库的