Case sensitivity problems with user name

Поиск
Список
Период
Сортировка
От Will Rutherdale (rutherw)
Тема Case sensitivity problems with user name
Дата
Msg-id 50A8E1F8D9122546A7F67134915EDB7A3B8E3F@xmb-rtp-21a.amer.cisco.com
обсуждение исходный текст
Ответ на Res: [win32] 8.3.5 -> 8.3.7 install trouble  (Berdam <berdamzinho@yahoo.com.br>)
Ответы Re: Case sensitivity problems with user name  (John R Pierce <pierce@hogranch.com>)
Список 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

 

В списке pgsql-general по дате отправления:

Предыдущее
От: Berdam
Дата:
Сообщение: Res: [win32] 8.3.5 -> 8.3.7 install trouble
Следующее
От: John R Pierce
Дата:
Сообщение: Re: Case sensitivity problems with user name