I created a user
createuser and didn't supply any passwords for it, i.e. no
-P option specified. I then proceeded to add the following line above all other lines in the
host all john 127.0.0.1/32 trust
I then restarted the server but even after that, when I try to run
psql -U john it keeps asking for a password. I even ran the command
psql -c "alter role john with password null;" but it changed nothing. PostgreSQL keeps asking for a password for
john. What am I missing?
Running PostgreSQL 13.2 on Windows 10.