On 04/02/2014 10:01 AM, Shaun Thomas wrote:
Hey,
So, I've gotten this on 9.3.4 after having a complaint from a user with
a hyphen in his name, but I dug further.
This is at the top of my pg_hba.conf file:
local all all peer map=local
And this is my pg_ident.conf:
local dude-guy dudeguy
local /(.*)$ \1
I've reloaded configs, and even went as far as to restart the database.
Yet the errors I get in the logs say this:
2014-04-02 10:39:59 CDT|LOG: no match in usermap "local" for user
"dude-guy" authenticated as "dude-guy"
2014-04-02 10:39:59 CDT|FATAL: Peer authentication failed for user
"dude-guy"
2014-04-02 10:39:59 CDT|DETAIL: Connection matched pg_hba.conf line 84:
"local all all peer map=local"
What's going on, here? Shouldn't it be checking for peer auth before
applying the mapping? Am I missing something?
Who are you connecting as dude-guy or dudeguy?
Looks to me like:
psql -d some_db -U dude-guy
From here:
http://www.postgresql.org/docs/9.3/interactive/auth-username-maps.html
Example 19.2
If I am following you are restricting dude-guy to logging in as dudeguy.
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
