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