| From: | Molly Gibson <molly_gibson2002(at)yahoo(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Need Clarification re md5 and pg_shadow files. |
| Date: | 2003-04-11 18:06:28 |
| Message-ID: | 20030411180628.11286.qmail@web41803.mail.yahoo.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
####Background:
Postgres 7.2.2
Created a user/pwd combo (with CREATE USER), then
granted the user select permissions on certain views.
It works locally, but the user would like to connect
from his own machine.
Added a line to pg_hba.conf for this user's machine:
host testdb1 10.10.4.2 255.255.255.255 md5
This works, everyone's happy.
####The question:
Here's where I'm confused: the instructions in
pg_hba.conf say "md5 can use usernames stored in
secondary password files but ignores passwords stored
there. The pg_shadow password will always be used."
I don't have a pg_shadow file, only a pg_pwd file.
Maybe I just don't know where to find it. ;) So how
is this working without a pg_shadow file, or am I
misunderstanding the instructions in thinking that
it's required? Wrong/no passwords result in an auth
failure, so it's getting the password from
_somewhere_.
Thanks!
mol
__________________________________________________
Do you Yahoo!?
Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop!
http://platinum.yahoo.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ericson Smith | 2003-04-11 18:15:24 | Re: (mysql to postgresql) in php functions |
| Previous Message | scott.marlowe | 2003-04-11 17:38:58 | Re: Problems with Initdb in WindosXP |