postgresql authentication - Mailing list 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