Connecting to PostgreSQL 15 - Connecttion Timed Out error from n8n node

Questions
1

I continually get a “Connection Timed Out” error when trying to connect to my PostgreSQL 15 database. The database is running on a Windows 10 Pro VM under VirtualBox. I can ping the server’s IP address just fine. The PostgreSQL 15 config files; pg_hba.config and postgresql.conf are set up to allow remote client authorization. I am also using a Host Only network on VirtualBox.

Any ideas or suggestion would be appreciated.

What is the error message (if any)? Connection Timed Out

Please share your workflow: None yet, just trying to connect the node

(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: 0.236.3
  • Database (default: SQLite): default
  • n8n EXECUTIONS_PROCESS setting (default: own, main): default
  • Running n8n via (Docker, npm, n8n cloud, desktop app): npm
  • Operating system: Windows 10 Pro
2

Hey @fdavidg,

It sounds like it is probably a config issue / network setting somewhere, Assuming n8n is running on npm on your desktop and not in another vm I would have thought it would work.

Have you tried using another postgres tool from where n8n is running to see if that can connect? I would generally avoid ping as a test as well as that only tells you that something is there it doesn’t test the port or protocol that you will connect with.

2 Likes
3

Hi Jon,

Yeah, the issue WAS a d–m-d config issue. I forgot Micro$oft starts their Firewall on installation of Windows 10 Pro and I neglected to allow the port, etc., etc.

Thank you for the help. I was pulling my hair out!

Frank

2 Likes
4

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