:red_circle: N8N can't connect to PostgreSQL (timeout after 60s)
drpauloguimaraesjr
PROOP

3 months ago

Hi team! 👋

Problem:
N8N service cannot connect to PostgreSQL, even though both are running in the same project with Private Networking enabled.

PostgreSQL status: ✅ Running fine
Logs show: database system is ready to accept connections

N8N status: ❌ Crash loop
Error: Could not establish database connection within the configured timeout of 60,000 ms

Environment Variables (N8N):

$10 Bounty

6 Replies

catlocky
HOBBY

3 months ago

Make sure that you are using the internal service name provided by Railway as DB_POSTGRESDB_HOST, not localhost or the public hostname. Make sure the Postgresql service allows connections from the N8N service, the port 5432 is accessible internally, and the credentials match. The connection timeout can be increased if needed

0x5b62656e5d
FREETop 1% Contributor

3 months ago

Note that you'll be charged egress fees when using the public URL to access the database.

brody
EMPLOYEE

3 months ago

You’re absolutely right

noahd
EMPLOYEE

3 months ago

<:mcconaughey:1438139467771674644>

rubysilver
PRO

3 months ago

Hm so what would be the best way to execute a python script that might add 10s of millions of rows from a python file?

Loading...