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 ...

It works!

What can I do to clean up everything?

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.