[NCLUG] Postfgres user/password question

[Erich]

Sean writes-
>Yes, but if you want to give a system user access they
need 
>to have a
>postgresql username/password.  I usually give system users

>a postgresql
>user as well, if they need access to the database.

OK, I have done this using the create_user command.  I have
also entered passwords.  However, remote users connecting
through psql cannot log on.  I see in the pg_hba.conf
documentation that the passwords nee to be in the pg_shadow
file.  Where should this be located for the users to
authinticate via the md5 option in pg_hba.conf??

As it stands, I have the system authinticating all valid
IP's, whic his fine for now, but I will need to close this
down *significantly*.

Erich

=====
No! There are no significant bugs in our released software that any significant number of users want fixed.
Bill Gates, interview with Focus magazine, 1995.  http://www.cantrip.org/nobugs.html

__________________________________________________
Do you Yahoo!?
Yahoo! Tax Center - forms, calculators, tips, more
http://taxes.yahoo.com/