Restarted fly postgres database and can no longer connect from phoenix app

Questions / Help Build debugging
,
1

Hello

I stopped and started my fly io database to do some health check testing.
I did this same thing the other day and things worked as expected.

But this time my fly phoenix app can no longer connect to the database. Below are the error messages I’m getting from my db and fly app.

db

2024-06-20 11:33:50.239	
flypg    | 2024-06-20 15:33:50.237 UTC [950] DETAIL:  Role "dtannerjr_350gjxvkqd6er9ql" does not exist.


2024-06-20 11:33:50.239	
flypg    | 2024-06-20 15:33:50.237 UTC [950] FATAL:  password authentication failed for user "dtannerjr_350gjxvkqd6er9ql"

app

15:38:14.263 [error] Postgrex.Protocol (#PID<0.1995.0>) failed to connect: ** (Postgrex.Error) FATAL 28P01 (invalid_password) password authentication failed for user "dtannerjr_350gjxvkqd6er9ql"

On stopping and restarting a database does it remove your roles or password?
This app has been up for the past few years and not sure why restarting the database has changed things.

Thanks for your responses.

2

I’m not sure what the issue is. But restarting and starting up the databases again seems to have fixed the issue. Though I’m not sure why restarting them in the first place created a role issue. Then restarting them again fixed it.

3

Kinda weird why I encountered auth error when I created a new Phoenix app then once restarted it, it acted like the auth error like OP.