I intend to use psql on Ubuntu. To authenticate, I used many things in the past:
- Simply write password when asking
- .pgpass file
- PGPASSWORD variable
This was several weeks ago. I think my attempts were not clean and I kinda messed up my configuration: I deleted the .pgpass file and the PGPASSWORD variable but I get this error:
psql: error: server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request.
It don't even ask for a password.
The fun fact is that when an admin connect on my computer and try whith :
sudo -u myuser psql ...
What can I do to clean up everything?