user auth & passwords

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

Browse pgsql-admin by date

  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