AWS Glue not able to connect to AWS RDS Aurora PostgreSQL instance

0

I am setting up the Connection in AWS Glue, trying to connect to my dev db instance (AWS rds Aurora PostgreSQL), I double checked VPC, subnet and setup the inbound rule to allow incoming connections to the db. At the step of "Test Connection", it failed and providing me the following error message (not much information I can follow for debugging):

No older events at this moment. Retry 2024-05-20T08:36:13.863Z ERROR StatusLogger Unrecognized format specifier [d] 2024-05-20T08:36:13.866Z ERROR StatusLogger Unrecognized conversion specifier [d] starting at position 16 in conversion pattern. 2024-05-20T08:36:13.866Z 2024-05-20T08:36:13.868Z ERROR StatusLogger Unrecognized format specifier [thread] 2024-05-20T08:36:13.868Z ERROR StatusLogger Unrecognized conversion specifier [thread] starting at position 25 in conversion pattern. 2024-05-20T08:36:13.868Z ERROR StatusLogger Unrecognized format specifier [level] 2024-05-20T08:36:13.868Z ERROR StatusLogger Unrecognized conversion specifier [level] starting at position 35 in conversion pattern. 2024-05-20T08:36:13.868Z ERROR StatusLogger Unrecognized format specifier [logger] 2024-05-20T08:36:13.869Z ERROR StatusLogger Unrecognized conversion specifier [logger] starting at position 47 in conversion pattern. 2024-05-20T08:36:13.869Z ERROR StatusLogger Unrecognized format specifier [msg] 2024-05-20T08:36:13.869Z ERROR StatusLogger Unrecognized conversion specifier [msg] starting at position 54 in conversion pattern. 2024-05-20T08:36:13.869Z ERROR StatusLogger Unrecognized format specifier [n] 2024-05-20T08:36:13.869Z ERROR StatusLogger Unrecognized conversion specifier [n] starting at position 56 in conversion pattern. 2024-05-20T08:36:13.889Z ERROR StatusLogger Unrecognized format specifier [d] ERROR StatusLogger Unrecognized conversion specifier [d] starting at position 16 in conversion pattern. 2024-05-20T08:36:13.890Z 2024-05-20T08:36:13.890Z ERROR StatusLogger Unrecognized format specifier [thread] 2024-05-20T08:36:13.890Z ERROR StatusLogger Unrecognized conversion specifier [thread] starting at position 25 in conversion pattern. 2024-05-20T08:36:13.891Z ERROR StatusLogger Unrecognized format specifier [level] 2024-05-20T08:36:13.891Z ERROR StatusLogger Unrecognized conversion specifier [level] starting at position 35 in conversion pattern. 2024-05-20T08:36:13.891Z ERROR StatusLogger Unrecognized format specifier [logger] 2024-05-20T08:36:13.891Z ERROR StatusLogger Unrecognized conversion specifier [logger] starting at position 47 in conversion pattern. 2024-05-20T08:36:14.061Z ERROR StatusLogger Unrecognized format specifier [msg] 2024-05-20T08:36:14.061Z ERROR StatusLogger Unrecognized conversion specifier [msg] starting at position 54 in conversion pattern. 2024-05-20T08:36:14.062Z ERROR StatusLogger Unrecognized format specifier [n] 2024-05-20T08:36:14.062Z ERROR StatusLogger Unrecognized conversion specifier [n] starting at position 56 in conversion pattern. No newer events at this moment. Auto retry paused.

Please help!

BTW, I am able to connect to the db instance using DBVisualizer using the same username and password, so login has no problem.

1 回答
0
profile picture
专家
已回答 7 个月前

您未登录。 登录 发布回答。

一个好的回答可以清楚地解答问题和提供建设性反馈,并能促进提问者的职业发展。

回答问题的准则