From: | Hal Lynch <hal(at)cc(dot)usu(dot)edu> |
---|---|
To: | pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
Subject: | postgresql authentication |
Date: | 2002-05-01 19:55:21 |
Message-ID: | 5EB5B512-5D3D-11D6-98A1-0050E490FD5B@cc.usu.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
I want to require users to authenticate themselves by entering
a username and/or password when:
using the psql command
connecting to a database using the perl interface module.
I am doing this on my 7.1.2 system.
I am trying to do this on my 7.2.1 system.
I have used creatuser and pg_password.
my pg_hba.conf file has the following line:
local all password passwd
"select * from pg_shadow;" and "select * from pg_user;" shows
the users I have added but "psql template1" still does not
require a username and/or password.
I have checked the pertinent (I think) parts of the book
"PostgreSQL Introduction and Concepts" and the administrators guide
on the web site.
Can some kind soul give me a clue how to do it, or where to look
for instructions?
hal
From | Date | Subject | |
---|---|---|---|
Next Message | Jean-Michel POURE | 2002-05-01 22:09:40 | Re: postgresql authentication |
Previous Message | Michael Glenn | 2002-05-01 19:45:46 | Re: Database 'xxxx', OID yyyyy, has disappeared from pg_database |