Database connection failed
Hey team I am getting an issue connecting to my new migrated postgres DB.
Project ID: 32337fdc-fe2a-42f0-a2be-bf2ec7720827
π thanks in advance
Solution:Jump to solution
Problem solved, I had to destroy everything and recreate new db and volume.
15 Replies
Project ID:
32337fdc-fe2a-42f0-a2be-bf2ec7720827Info when I try to CLI connect:
psql: error: connection to server at "monorail.proxy.rlwy.net" (35.213.165.89), port 56612 failed: server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
firstly can you show a screenshot of your railway project so i know whats going on
can you try re-deploying the database
I did - same issue
I also tried restarting
I also made sure the port for the proxy was the same as the db port
show me the public networking section please
that's wrong, you should set the proxy to port 5432
Same message:
psql: error: connection to server at "monorail.proxy.rlwy.net" (35.213.165.89), port 16989 failed: server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
See screenshot of my new settings
redeploy?
psql: error: connection to server at "monorail.proxy.rlwy.net" (35.213.165.89), port 16989 failed: FATAL: password authentication failed for user "postgres"
connection to server at "monorail.proxy.rlwy.net" (35.213.165.89), port 16989 failed: FATAL: password authentication failed for user "postgres"
@Brody Is this because maybe the old volume was attached to the new DB?
if you're passing volumes around then you've likely broken something
Solution
Problem solved, I had to destroy everything and recreate new db and volume.
makes sense