From: | "Will Rutherdale (rutherw)" <rutherw(at)cisco(dot)com> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Case sensitivity problems with user name |
Date: | 2009-03-24 19:23:08 |
Message-ID: | 50A8E1F8D9122546A7F67134915EDB7A3B8E3F@xmb-rtp-21a.amer.cisco.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi.
I have a little problem with user names and Postgres commands.
Due to quirks in corporate account management using ADS, some user names
come out as, say, Mickey when you log into Linux instead of mickey.
This unfortunate user tries to run Postgres commands and gets for
instance:
$ psql
psql: FATAL: database "Mickey" does not exist
$ id
uid=123456(Mickey) gid=...
$ pg_dump >dump.out
pg_dump: [archiver (db)] connection to database "Mickey" failed: FATAL:
database "Mickey" does not exist
$ psql mickey mickey
Welcome to psql 8.3.6, the PostgreSQL interactive terminal.
. . .
I have set up pg_hba.conf with lines like
local all all trust
host all all 127.0.0.1/32 trust
I tried modifying pg_ident.conf but couldn't get any results.
When I try going into psql as user postgres to change the user name, I
get this problem:
postgres=# alter user mickey rename to Mickey;
ERROR: role "mickey" already exists
What can I do so that the default user is accepted? I would like the
user to be able to just type:
$ psql
and get in successfully.
Any help would be appreciated.
-Will
From | Date | Subject | |
---|---|---|---|
Next Message | Randall Lucas | 2009-03-24 19:54:54 | Re: Defer a functional index calculation? |
Previous Message | Berdam | 2009-03-24 16:38:03 | Res: [win32] 8.3.5 -> 8.3.7 install trouble |