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)