Major newbie

Hi,

I am very new to PostgreSQL and PERL. I am trying to fix up a system that
has no passwords on the PostgreSQL system by adding passwords.

1. What is the difference between the 'local' entry in the pg_hba.conf
file and the 'host 127.0.0.1' entry?

2. Can I add passwords partially to the system?

3. If I get passwords added, is there some way to specify the passwords on
the 'pgsql' command line without adding the -u switch and specifying (at
the prompt) the user name and the password?

4. Is a PERL script file coming into the database by the entry (in
pg_hba.conf file) as 'local' or as 'host 127.0.0.1' entry?

5. How do I add passwords on the database open in the PERL script file so
that the password is specified in the program?

I am not sure if these questions can be answered without knowing a lot more
about our setup, but if someone can write back with questions, then I can
possibly answer them.

TIA,

David