Re: ident authentication problems postgresql 9.2

On 10/16/2013 06:56 AM, Rory Campbell-Lange wrote:
> I have just done an update on my Debian servers running postgresql 9.2
> (Postgres is from 9.2.4-2.pgdg70+1 from apt.postgresql.org) and suddenly
> can't login to postgresql as postgres with the normal peer/ident
> authentication over a local Unix socket.

So is there any pertinent information in either the Postgres or system logs?

>
> I've worked around it (I'm using md5 for the time being) but I wonder if
> anyone else has experienced this problem which is affecting all 3 of my
> 9.2 servers.
>
> I can't find anything in the recent Debian security updates that could
> have broken this (i.e. recent stuff at http://www.debian.org/security/)
>
> By the way there is a key expired error on http://apt.postgresql.org.

An explanation and fix for the key expired error can be found here:

http://blog.endpoint.com/2013/10/postgresql-debian-apt-repository-gnupg.html

>
> Regards
> Rory
>
>

--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com