R
Railway•7mo ago
Capuccio

Database Connection

Hi, I change the volume from another container to this new one but when I did the new container show this, I ran the command with SET, etc. (powershell) but always getting same error message: password authentication failed for user "postgres" connection to server at "monorail.proxy.rlwy.net" (35.212.45.179), port 32443 failed: FATAL: password authentication failed for user "postgres" and I have typed the password correctly.
No description
Solution:
you need to use the same password as the original database, if you lost this there's nothing railway can do for you, sorry
Jump to solution
11 Replies
Percy
Percy•7mo ago
Project ID: 876cd491-08ac-4c2f-a9dc-54a212cf38f5
Capuccio
Capuccio•7mo ago
876cd491-08ac-4c2f-a9dc-54a212cf38f5
Brody
Brody•7mo ago
you volume swapped two postgres containers?
Capuccio
Capuccio•7mo ago
Yes, I disconnected the volume from a Postgres container and deleted that container, created a new one and when I connect the volume to it it gives me an error Checking, the path is the one that gives the error, if I put another one for example /var/lib/psql/data it works fine but it shows as if it had no tables When I use the path /var/lib/postgresql/data (the normal path the volume had) It does not work
Capuccio
Capuccio•7mo ago
It give me this logs when I try to connect
No description
Brody
Brody•7mo ago
you would need to use the credentials from the original postgres service that you used the volume from
Capuccio
Capuccio•7mo ago
But I deleted, there is not other way?| 😦
Brody
Brody•7mo ago
did you have important data?
Capuccio
Capuccio•7mo ago
Yes I was wondering, If I have to use the same pass, port, etc. as the original service, why we can disconnect the volume? xd
Solution
Brody
Brody•7mo ago
you need to use the same password as the original database, if you lost this there's nothing railway can do for you, sorry
Capuccio
Capuccio•7mo ago
I see, thanks for your help how I close this thread? :v