Can't connect to PostgreSQL 15.2 database using the Postgres node

Questions
1

I have a PostgreSQL 15.2 database running on a Windows 10 Pro Virtual Machine. I can ping the VM just fine. When I try to connect the Postgres node to the data base the connection times out. I am able to insert data from other applications into the database, etc. just fine. Can I use the IP address of the VM as the Host in the Postgres node instead of localhost?

Connection timed out.

Not really a workflow yet, I am just trying to setup the Postgres 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): PostgreSQL 15.2
  • n8n EXECUTIONS_PROCESS setting (default: own, main): default
  • Running n8n via (Docker, npm, n8n cloud, desktop app): npm
  • Operating system: Windows 10 Pro
3

Why don’t you run the Docker-Compose, it is easier to set up and update.

I started/setup mine via the Linux Console then manage it via Docker-Desktop

image
image1227×232 13.3 KB

Otherwise why your Postgres it’s not working?

It’s maybe because you need to initialize the database as the docker-compose do :wink:

1 Like
4

So today I went backward from the latest Postgres until the init-data.sh works and:

  • PostgreSQL 16-alpine: doesn’t work; impossible to do the migration
  • PostgreSQL 15-alpine: doesn’t work; impossible to do the migration
  • PostgreSQL 14-alpine: WORKS