I can successfully connect with every user except one. I always get "password authentication failed for user" even after changing the password. This worked before the last time the server restarted. (maybe something corrupted?)
After some time of trying to fix this issue I decided to just create a new user. However, I get the same problem with any new user that I create.
I just executed this:
postgres@server:~$ psql
psql (9.6.13)
Type "help" for help.
postgres=# CREATE USER test WITH PASSWORD 'test';
CREATE ROLE
postgres=# CREATE DATABASE test;
CREATE DATABASE
postgres=# GRANT ALL ON DATABASE test TO test;
GRANT
postgres=# \q
postgres@server:~$ psql -U test -d test -h localhost
Password for user test:
psql: FATAL: password authentication failed for user "test"
FATAL: password authentication failed for user "test"
I am pretty sure I did not mistype the password here.
My pg_hba.conf contains the following line:
host all all 127.0.0.1/32 md5
I am quite a bit lost as to what I should do to fix this issue.