On 04/02/2014 01:35 PM, Shaun Thomas wrote:
> On 04/02/2014 03:27 PM, Adrian Klaver wrote:
>
>> Who are you connecting as dude-guy or dudeguy?
>>
>> Looks to me like:
>>
>> psql -d some_db -U dude-guy
>
> You are correct. I was assuming the translation went system ->
> PostgreSQL, not the other way around. Like, by setting -U dude-guy,
> PostgreSQL checked peer auth, then applied the mapping to find and apply
> the database username.
>
> Not sure why I had it backwards, but thanks. :)
FYI this works:
postgres@test=# CREATE ROLE dude_guy;
CREATE ROLE
If you want a sort of hyphen.
>
--
Adrian Klaver
adrian.klaver@aklaver.com