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@xxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
