17 days 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):
6 Replies
17 days 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
10 days ago
Note that you'll be charged egress fees when using the public URL to access the database.
10 days ago
You’re absolutely right
10 days ago
10 days ago
<:mcconaughey:1438139467771674644>
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?