postgresql authentication

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

Responses

Browse pgsql-admin by date

  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