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