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.klaver@gmail.com