FATAL: Ident authentication failed for user “xyzw” (PG::ConnectionBad)

adamo Uncategorized 2014/11/232014/11/23 1 Minute

But according to pg_hba.conf I am not connecting using ident on localhost:

host all all 127.0.0.1/32 md5

or am I?

host all all ::1/128 ident

Because you know, ::1 is localhost also and you can easily overlook this. Never forget IPv6 even when dealing with localhost.

Published by adamo

I am a Greek DevOps Engineer ranting about everything, from email to sports; to living in Athens, Greece. View all posts by adamo

Published 2014/11/232014/11/23

Sotiris Tsimbonis says:

2014/11/23 at 22:53
Actually, on RHEL family distros only 127.0.0.1 is localhost by default. ::1 is localhost6.
```
[stsimb@zm-in-01 ~]$ grep localhost /etc/hosts
127.0.0.1       localhost.localdomain localhost
::1             localhost6.localdomain6 localhost6
```
But this has backfired on me too, some milter expected that localhost would get it to connect to ::1, but it didn’t (ref).
Reply
1. adamo says:
  
  2014/11/23 at 22:55
  
  Interesting, since this happened to me today on a CentOS 6.6.
  
  Reply