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