R
Railway•4mo ago
Antonio_cl

Postgres Variables messed up

How can i enter the postgresdb to recover some data that i have? i did some updated and nothing is working. It is requiring variables that are set up so i do not get how can i enter.
No description
No description
Solution:
looks like the migrations aren't valid for the ai image, the variables have been restored on the database and the primary service is back to the regular n8n image, please log in and export the data from within n8n so that we can try a fresh install with the ai image
Jump to solution
25 Replies
Percy
Percy•4mo ago
Project ID: dcfa6c76-82dc-4304-9f0a-faeca3f0da9b
Antonio_cl
Antonio_cl•4mo ago
dcfa6c76-82dc-4304-9f0a-faeca3f0da9b
Brody
Brody•4mo ago
use the database url in software like dbgate, please ignore the data tab
Antonio_cl
Antonio_cl•4mo ago
thanks, Brody.
Antonio_cl
Antonio_cl•4mo ago
Mm i am getting an error: either with the public and private url
No description
Brody
Brody•4mo ago
please use the public url aka the one that doesn't say private
Antonio_cl
Antonio_cl•4mo ago
i am using DATABASE_URL but it has .internal in it and is not working
Brody
Brody•4mo ago
please use DATABASE_URL from the database service itself not your app service
Antonio_cl
Antonio_cl•4mo ago
postgres://railway:superpassword@postgres-production-d664.up.railway.app:5432/railway not working, timing out
Brody
Brody•4mo ago
okay thats really not what it should be, would you mind adding me to your project so i can see if i can fix this stuff up
Antonio_cl
Antonio_cl•4mo ago
sent you an invitation via message
Brody
Brody•4mo ago
looking
Antonio_cl
Antonio_cl•4mo ago
tahnks
Brody
Brody•4mo ago
this project was created from this template originally right? https://railway.app/template/r2SNX_
Antonio_cl
Antonio_cl•4mo ago
yes then i changed the image for the ai-beta and today i redeploy some of them and it fucked up everything
Brody
Brody•4mo ago
will try my best to get you sorted
Antonio_cl
Antonio_cl•4mo ago
thanks. If not i wil l have to start over. That's it.
Solution
Brody
Brody•4mo ago
looks like the migrations aren't valid for the ai image, the variables have been restored on the database and the primary service is back to the regular n8n image, please log in and export the data from within n8n so that we can try a fresh install with the ai image
Antonio_cl
Antonio_cl•4mo ago
Thanks, Brody. No worries about ai image. I will keep using the normal version as now they added ai on it Will check if i can connect
Brody
Brody•4mo ago
oh so theres not even a need for the ai image anymore? unless you want the beta stuff?
Antonio_cl
Antonio_cl•4mo ago
indeed. At least that is what i found out today thanks buddy! i was able to enter again
Brody
Brody•4mo ago
everything look good?
Antonio_cl
Antonio_cl•4mo ago
yes! i think the cloud as explained is only working on their cloud (wrong) i will be able to copy all the nodes thanks a lot!
Brody
Brody•4mo ago
no problem, i shall leave the project now
Antonio_cl
Antonio_cl•4mo ago
💯
No description