Postgres Connection connects, but then when used in flow fails to connect

Questions
1

I have just started using n8n and looking to set up a connection to my postgres database, hosted on AWS RDS through a SSH tunnel.

I am running n8n on a docker container on my local computer.

I created the connection in the connection settings, and when I click test it succeeds.

However, when I go to use it in a flow, and get to a stage that actually connects to the db (such as selecting the schema / table) I get the following error:

Error: getaddrinfo EAI_AGAIN xxx.yyyy.zzz.eu-west-2.rds.amazonaws.com
    at GetAddrInfoReqWrap.onlookup [as oncomplete] (node:dns:107:26)
3

Hi @kicks66 :wave: Welcome to the community :tada:

EAI_AGAIN isn’t an n8n-specific error but suggests network problems (specifically, resolving the domain name on AWS seems to fail here). Is there any chance the way you’re using AWS restricts DNS lookups from docker containers or other network traffic for whatever reason? Or could this have been a temporary problem with the name resolution in your network?

4

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