n8n Connection Issue with Postgres - Primary Now Fails To Deploy

dc-aaiaHOBBY

3 months ago

I was attempting to complete configuration of an n8n Workflow Backup imported from an Enterprise template which required various adjustments for the n8n Community Edition. All was going well until and I was using Perplexity w/ DeepSeek R1 to provide assistance until Perplexity had me add a series of Shared Variables. Then after specifically adding the variables “N8NENDPOINTREST” and “N8NENDPOINTREST_OLD”, the system crashed and now Primary fails upon deployment and redeployment. It looks like a communication conflict with connecting to Postgres. I have subsequently updated the Shared Variables in an attempt to correct them, but it appears that the Key: Value pairs register if the value is text, but will not register and resolve the values using Templated values, showing in the main Variables sections in Primary and Postgres when clicking the view icon. Conversely, if I select the Edit field control, the Templated value is displayed.
I am running n8n Community Edition in Queue Mode w/ Webhook processors on the Hobby Plan.
I have a number of n8n workflows I have installed and partially configured and why I was installing to execute a backup workflow as my first executable.
Any assistance is greatly appreciated as I don’t want to have to start over, and the Postgres database itself appears to be okay if I needed to make a backup of the JSON files to reimport with a new instance of n8n should this not be fixable.
Note I am a low code/no guy and am in deep water within Railway, albeit is a very cool hosting app. So step by step guidance would be greatly appreciated.
Thanks in advance for your assistance,

DC

Logs (Excerpt):
Primary
620a447d-803f-40a4-9f6a-5c8f238f9dda
FAILED primary-production-b0359.up.railway.app
Deployment failed during the network process > Network > Healthcheck > Healthcheck failure
Deploy Logs:
Feb 01 23:35:51
connect ECONNREFUSED ::1:5432
Feb 01 23:35:55
User settings loaded from: /home/node/.n8n/config
Feb 01 23:35:57
Last session crashed
Feb 01 23:36:17
Initializing n8n process
Feb 01 23:36:17
There was an error initializing DB
Feb 01 23:36:17
connect ECONNREFUSED ::1:5432
Feb 01 23:36:17
User settings loaded from: /home/node/.n8n/config
Feb 01 23:36:17
Last session crashed
Feb 01 23:36:24
Initializing n8n process
Feb 01 23:36:25
There was an error initializing DB
Feb 01 23:36:25
connect ECONNREFUSED ::1:5432
Feb 01 23:41:36
Stopping Container

23 Variables
DBPOSTGRESDBPORT = ${{shared.DBPOSTGRESDBPORT}}
repopath = ${{shared.repopath}}
ENABLEALPINEPRIVATENETWORKING = true N8NENCRYPTIONKEY = roqmicVQhJyJ-Idr95g2!UgbI5-ItZ8
DBPOSTGRESDBPASSWORD = ${{shared.DBPOSTGRESDBPASSWORD}}
QUEUEBULLREDISHOST = ${{shared.QUEUEBULLREDISHOST}}
DBTYPE = ${{shared.DBTYPE}}
DBPOSTGRESDBHOST = ${{shared.DBPOSTGRESDBHOST}}
PORT = 5678
QUEUEBULLREDISUSERNAME = ${{28e7c8af-f77e-43b6-8ed1-2eeb565798af.REDISUSER}} QUEUEBULLREDISPORT = ${{shared.QUEUEBULLREDISPORT}} DBPOSTGRESDBCONNECTIONTIMEOUT = ${{shared.DBPOSTGRESDBCONNECTIONTIMEOUT}} N8NTRUSTPROX = ${{shared.N8NTRUSTPROX}} repoowner = ${{shared.repoowner}} EXECUTIONSMODE = queue
N8NLISTENADDRESS = ::
DBPOSTGRESDBDATABASE = ${{shared.DBPOSTGRESDBDATABASE}}
DBPOSTGRESDBUSER = ${{shared.DBPOSTGRESDBUSER}}
N8NDISABLEPRODUCTIONMAINPROCESS = true
N8NEDITORBASEURL = https://${{RAILWAYPUBLICDOMAIN}} N8NENFORCESETTINGSFILEPERMISSIONS = ${{shared.N8NENFORCESETTINGSFILEPERMISSIONS}} reponame = ${{shared.reponame}} WEBHOOKURL = https://${{f4d1b7da-997c-43ff-8657-c2297da562e1.RAILWAYPUBLICDOMAIN}}

View Deploy details

> ⓘ Deployment information is only viewable by project members and Railway employees.

Solved

19 Replies

israelmirskyPRO

3 months ago


dc-aaiaHOBBY

3 months ago

I thought the same potentially, and subscribed to your thread just before posting last night. I'm new to n8n CE on Railway, been running ~one week. How responsive does getting support tend to be?


3 months ago

For Hobby, within a few days, for Pro, within 12 hours, for enterprise, within 1 hour.

Looking now though.


dc-aaiaHOBBY

3 months ago

Now that was a perfectly timed segue. Thank you, brody, for getting to this so quickly. Please let me know if you need additional details.


3 months ago

So you had made a lot of incorrect configurations, mainly promoting a bunch of variables to be shared variables.

I have undone all that for you.

Going forward, please do not do such things with deployed templates again.


brody

So you had made a lot of incorrect configurations, mainly promoting a bunch of variables to be shared variables.I have undone all that for you.Going forward, please do not do such things with deployed templates again.

dc-aaiaHOBBY

3 months ago

Thank you, brody, great job and it is very much appreciated. Moving forward, I'll stick with sourcing assistance here instead of LLMs.


brody

So you had made a lot of incorrect configurations, mainly promoting a bunch of variables to be shared variables.I have undone all that for you.Going forward, please do not do such things with deployed templates again.

dc-aaiaHOBBY

3 months ago

brody, looks like I have one additional issue. I cannot login to the n8n app itself, but I am able to login to Railway and my Ghost instance. Error message says Recover Email - Please contact your admin. n8n isn’t set up to send email right now. Please advise when you can. Thanks - DC


3 months ago

You forgot your N8N login?


brody

You forgot your N8N login?

dc-aaiaHOBBY

3 months ago

Actually no, it's in Microsoft Wallet, it's just not working for n8n, but is for Ghost. Same login, difference password of course.


3 months ago

I'm not sure why you are mentioning Ghost?

N8N and Ghost are completely different software.


brody

I'm not sure why you are mentioning Ghost?N8N and Ghost are completely different software.

dc-aaiaHOBBY

3 months ago

Simply because they're both deployed on Railway.


3 months ago

Gotcha, there's no real relevance there.

You perhaps changed your encryption key incorrectly too, I will look into that when I'm back at my laptop in a few minutes.


brody

Gotcha, there's no real relevance there.You perhaps changed your encryption key incorrectly too, I will look into that when I'm back at my laptop in a few minutes.

dc-aaiaHOBBY

3 months ago

You are golden, Brother. Thanks so much. Maybe it would be good for me to reset my password if possible. i know I wigged things out quite a bit last night.


3 months ago

Please try logging in with the new password set in the NEW_PASSWORD variable on the Primary service.

Please note, that variable has nothing to do with how you change passwords in N8N or software hosted on Railway, I am just using that variable as a simple way to give you the new password given this a public thread.


brody

Please try logging in with the new password set in the NEW_PASSWORD variable on the Primary service.Please note, that variable has nothing to do with how you change passwords in N8N or software hosted on Railway, I am just using that variable as a simple way to give you the new password given this a public thread.

dc-aaiaHOBBY

3 months ago

Will do, standby


dc-aaia

Will do, standby

dc-aaiaHOBBY

3 months ago

Still not letting me in with the new password. And I am using my Gmail account.


3 months ago

Then you are using the wrong email, the email you signed up to N8N with was not a gmail address.


brody

Then you are using the wrong email, the email you signed up to N8N with was not a gmail address.

dc-aaiaHOBBY

3 months ago

Perfect, that got it. Thanks so much but not sure what happened as it was cached to my Gmail account and password. Just recently started using Wallet so maybe it's a browser conflict on my end. I've got it logged separately now. Outstanding support, brody. Thanks so much. Lunch is on me next time Brother - DC


3 months ago

Means your original password would have also likely worked if used the correct email.

Either way, happy it's working now!


Status changed to Solved brody 3 months ago