From: | Jason Dillon <user57(at)mpath(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | user auth & passwords |
Date: | 1998-06-04 00:09:08 |
Message-ID: | XFMail.980603170908.user57@mpath.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Oliver Elphick | 1998-06-04 03:46:44 | Re: [ADMIN] user auth & passwords |
Previous Message | Doug White | 1998-06-03 07:14:42 | Re: postgresql questions |