Connecting to AWS RDS

Hello!
I’ve configured a free AWS Aurora and RDS PostgresDB and I would like to connect to this DB using n8n cloud (not self hosted I’m using the simple n8n cloud).
I’m using a postgres node in n8n for connection.
I’m not a 100% sure if I configured everything correctly, but just to make sure, I’ve added the n8n cloud IP addresses that I found on the support page to the security roles.
I’m using SSL = TRUE, but I can’t provide the required AWS certificates to n8n.
I’m currently stuck with connecting to AWS.
Reading the forums I’m afraid that connecting to AWS postgres is not that straight forward.

I’m quite new to n8n and postgres, I might need to find a supported postgres provider to connect with n8n.
I would like to hear from you, if anyone succeeded connecting to AWS postgres without doing serious workarounds.
Any help and info is much much appreciated!

hello @L_C1

What is the error? Did you configure the security group so the n8n is able to reach your db instance?

1 Like

Hello! In the meantime I solved the case. I had to configure the security roles on aws and add 0.0.0.0 IP. Later when I go to production I’ll need to enable SSH. That’s all. :slight_smile: Thank you for the reply!

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.