Re: unable to connect to postgres db via psycopy

Thank you for the reply. In the past I have not used this file. Has
there been a recent change?

Should the new line be:

local all all md5

Below is the configuration section of pg_hba.conf:

# TYPE DATABASE USER ADDRESS METHOD

# "local" is for Unix domain socket connections only
local all all peer
# IPv4 local connections:
host all all 127.0.0.1/32 ident
# IPv6 local connections:
host all all ::1/128
ident
# Allow replication connections from localhost, by a user with the
# replication privilege.
#local replication postgres peer
#host replication postgres 127.0.0.1/32 ident
#host replication postgres ::1/128 ident

On 03/12/2016 05:26 PM, Christophe Pettus wrote:
> On Mar 12, 2016, at 5:23 PM, Dan Sawyer <dansawyer(at)earthlink(dot)net> wrote:
>
>> psycopg2.OperationalError: FATAL: Ident authentication failed for user "dan"
> The place to look is in your pg_hba.conf, and makes sure that user "dan" has MD5 password access turned on to the appropriate database(s) for localhost.
>
> --
> -- Christophe Pettus
> xof(at)thebuild(dot)com
>