user auth & passwords

Поиск
Список
Период
Сортировка
От Jason Dillon
Тема user auth & passwords
Дата
Msg-id XFMail.980603170908.user57@mpath.com
обсуждение исходный текст
Ответы Re: [ADMIN] user auth & passwords
Список pgsql-admin
For the life of me I can not find any substancial documentation on how to give
users passwords.  I have found the -a argument to many of the command line
tools, but I can't seem to figure out what they do.  I have also played with
pg_hba.conf, but this exercise has proved to be just as frustrating. I also
tried to use "create user" via psql, but it too did little.

I am trying to setup a database that will only allow users with the correct
encrypted passwords to access the system.  It does not appear to me that the
`createuser' tool has the ability to set user passwords.  I tryed creating
users with different settings for -a <system> but this did not really do
anything differently.

When I changed the auth setting in pg_hba.conf from trust to crypt or
password, I was unable to login with user postgres.  I had to set
local back to trust to be able to do anything.

I would really apreciate it if someone who knows how to create passwords for
users would drop some knowledge.  The lack of documentation is driving me nuts.

--jason

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