Re: ident authentication problems postgresql 9.2

On 16/10/13, Adrian Klaver (adrian.klaver@gmail.com) wrote:
> 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 just turned the setting in pg_hba.conf from md5 back to peer and
reloaded the server so that it now reads as:

    local   all             postgres                                peer

Attempting to log in fails with the following error on the console:

    psql: FATAL:  Peer authentication failed for user "postgres"

Thanks for the suggestion for checking the logs. My apologies for not
checking that. The logs show:

    2013-10-16 16:21:16 BST template1 LOG:  local user with ID <abc> does not exist
    2013-10-16 16:21:16 BST template1 FATAL:  Peer authentication failed for user "postgres"

However /etc/passwd has

    postgres:x:<abc>:<def>:PostgreSQL administrator,,,:/db:/bin/bash

I do not have an ident server running and never have had as far as I
recall.

> >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

Thanks very much. Removing /etc/apt/trusted.gpg.d/apt.postgresql.org.gpg
fixed the problem I was experiencing.

Thanks very much
Rory

--
Rory Campbell-Lange