Problem
After creating a new user with password in postgres and trying to login using the new user, postgres never asks for a password
Solution
Modify the pg_hba.conf file and change trust to md5, as follows:local all all md5
# IPv4 local connections:
host all all 127.0.0.1/32 md5
# IPv6 local connections:
host all all ::1/128 md5
No comments:
Post a Comment