Monday, July 2, 2012

Postgres not asking for password

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