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


---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly

Reply via email to