Skip to main content
1 of 3
Dave
  • 733
  • 10
  • 22
  • 38

How do I enable md5 authentication for only one user in PostGres 9.2?

I just installed PostGres 9.2 on CentOS 7. I want to keep peer authentication for all my users except one, which I would like to be able to access via "psql" through any user's account. I tried editing my /var/lib/pgsql/data/pg_hba.conf to be this

local   all             all                                     ident
local   all             scale                                   md5

but I'm still unable to login with the user "scale" unless I'm in that user's account. What do I need to do to set up md5 authentication for this one user only?

Dave
  • 733
  • 10
  • 22
  • 38