If you're using docker, make sure you're NOT using POSTGRES_USER=something_else
, as this variable is used by the standard image to know the name of the PostgreSQL admin user (default as postgres
).
In my case, I was using this variable with the intent to set another user to my specific database, but it ended up of course changing the main PostgreSQL user.