Reading list Switch to dark mode

    postgres ident authentication failed on windows

    Updated 26 March 2015

    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…

    Start your headless eCommerce
    now.
    Find out More

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

    . . .

    Leave a Comment

    Your email address will not be published. Required fields are marked*


    Be the first to comment.

    Back to Top

    Message Sent!

    If you have more details or questions, you can reply to the received confirmation email.

    Back to Home