I cannot connect to my AWS RDS PostgreSQL

[Bit_Dancing]

Describe the problem/error/question

What is the error message (if any)?

Please share your workflow

(Select the nodes on your canvas and use the keyboard shortcuts CMD+C/CTRL+C and CMD+V/CTRL+V to copy and paste the workflow.)

Share the output returned by the last node

Information on your n8n setup

• n8n version:
• Database (default: SQLite):
• n8n EXECUTIONS_PROCESS setting (default: own, main):
• Running n8n via (Docker, npm, n8n cloud, desktop app):
• Operating system:

[jksr]

@Bit_Dancing If this is on AWS, do you have a Security Group that allows inbound traffic from this IP? By default, the database would not allow traffic from outside.

[Bit_Dancing]

yeah i open all the traffic and all ports , but if i do this , ignore ssl issue , then connection works , but when i try to use this connection in AI Agent , then same error comes , weired

[Bit_Dancing]

i solve this by changing the postgre version on AWS , from 15, it force ssl certificate auth for security , and n8n cannot handle it , at least i don’t know for now , so i switch to postgres 14 then ssl certificate is not mandantory