postgres ident authentication failed on windows

To fix this error open PostgreSQL client authentication configuration file :…\PostgreSQL\data\pg_hba.conf

This file controls:

• Which hosts are allowed to connect
• How clients are authenticated
• Which PostgreSQL user names they can use
• Which databases they can access

By default Postgresql uses IDENT-based authentication. All you have to do is allow username and password based authentication for your network or webserver. IDENT will never allow you to login via -U and -W options. Append following to allow login via localhost only:

local	all	all	        trust
host	all	127.0.0.1/32	trust

Save and close the file. Restart Postgresql server:

Enjoy…

[stextbox id=”warning”]Your opinions, comments and suggestions are important to keep the page updated and interesting. [/stextbox]

Mohit Chandra 6 Badges

• 26 Mar, 2015
  Updated by - neha sharma
• 22 Jun, 2013
  Created by - Mohit Chandra