Directus: I need to access the postgreSQL database deployed on railway with directus

I created a flow on directus that affected authentication on login. i need to delete the directus flow on database to access it again. how do i do that. How to connect to the PostgreSQL database
21 Replies
Percy
Percy5mo ago
Project ID: da2d5174-a73f-4a30-a3e8-8ec821a0cf73
somemartin
somemartin5mo ago
da2d5174-a73f-4a30-a3e8-8ec821a0cf73
Brody
Brody5mo ago
what template did you deploy directus from?
somemartin
somemartin5mo ago
Directus api template
Brody
Brody5mo ago
we dont have any templates by that exact name, can you please link the template
somemartin
somemartin5mo ago
"Directus" is the main name
somemartin
somemartin5mo ago
No description
somemartin
somemartin5mo ago
this one.
Brody
Brody5mo ago
please read its overview - https://railway.app/template/2fy758
somemartin
somemartin5mo ago
Sorry, I still don't know how I'll access it
Brody
Brody5mo ago
have you read the notes section of the overview?
somemartin
somemartin5mo ago
Yes, I'm new to it, researched it also but still dont get it.
Brody
Brody5mo ago
have you added the tcp proxy to the postgres service?
somemartin
somemartin5mo ago
Yes I added. I'm trying access the postgresql through railway cli. an error is appearing when im running psql >railway run psql >psql: error: connection to server at "monorail.proxy.rlwy.net" ([IP REDACTED]), port [port REDACTED] failed: server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request. I'm already linked to the postgres service
Brody
Brody5mo ago
can you please send me a screenshot of the public networking section?
somemartin
somemartin5mo ago
here
No description
Brody
Brody5mo ago
go ahead and redeploy the postgres deployment
No description
somemartin
somemartin5mo ago
I see had progress. the railway cli is asking for a password for my account. but my account is linked on github. logged in via github
Brody
Brody5mo ago
the cli is never going to ask for a password for railway, either way, use dbgate to connect to the database
somemartin
somemartin5mo ago
Thanks Brody. already connected
Brody
Brody5mo ago
awsome