Re: ident authentication problems postgresql 9.2 - Mailing list pgsql-general

From John R Pierce
Subject Re: ident authentication problems postgresql 9.2
Date
Msg-id 525EF2AC.6060903@hogranch.com
Whole thread Raw
In response to Re: ident authentication problems postgresql 9.2  (Rory Campbell-Lange <rory@campbell-lange.net>)
List pgsql-general
On 10/16/2013 8:34 AM, Rory Campbell-Lange wrote:
> 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.

# su - postgres
$ psql


does that give the same error?

re ident server, domain sockets ('local') use a different mechanism, not
authd aka identd...  authd/identd would only be used if you specified
ident on a HOST connection, something I wouldn't recommend.



--
john r pierce                                      37N 122W
somewhere on the middle of the left coast



pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: ident authentication problems postgresql 9.2
Next
From: Bruce Momjian
Date:
Subject: Re: Problem with updating hstore extension from 9.2 to 9.3