Re: Password authentication

From: "G(dot) Anthony Reina" <gar8+(at)pitt(dot)edu>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Password authentication
Date: 2003-03-14 02:52:52
Message-ID: 16714454.1047592372@dell1.neurobio.pitt.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Ok. Thanks Bruce.

-Tony

--On Thursday, March 13, 2003 9:43 PM -0500 Bruce Momjian
<pgman(at)candle(dot)pha(dot)pa(dot)us> wrote:r

> Tony Reina wrote:
>> If I delcare md5 password authentication in pg_hba.conf, can I have
>> the password's verified by the OS's password list? Or, can it only
>> look at the password's specifically inserted into PostgreSQL?
>
> No, only from pg_shadow. In fact we removed the host password pg_passwd
> utility in 7.3 anyway.
>
> --
> Bruce Momjian | http://candle.pha.pa.us
> pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
> + If your life is a hard drive, | 13 Roberts Road
> + Christ can be your backup. | Newtown Square, Pennsylvania
> 19073

===========================

G. Anthony Reina, M.D.
University of Pittsburgh
The McGowan Center, Room 245
3025 East Carson Street
Pittsburgh, PA 15203
Voice (412) 383-6691
Fax (412) 383-6799

My public key is:
-----BEGIN PGP PUBLIC KEY BLOCK-----
Version: GnuPG v1.2.1 (MingW32) - WinPT 0.7.94

mQGiBD5xC3ERBADDFLEGBx9erPoX2L+5R/knLm0TgXFYzEqGKQwNA7vohkxYY6Wo
ximgJUI5buNFbyrPLkcr8ndvEpsVy7FItmiXXecaTFQy9cebx3TFXg4s+1LigHZS
e4PIQoqWcicfTbatz6bQcucuOqHttGUvr7b6d1Z5do5bkfdxYGEgU7yR7wCgnRyc
OFE+BJR1dRyCVh95u1s1shkEAKdvl0bLUkcyxuDYYadCZeftsNCRcIVwSset5m21
6SJuNGQbp2GNTBPrBZQdR3Wqo9K4H3l99Tw1FVowHbvRwCThgXXbY2Bqu1W7BWp+
W2seE5epbNc+ZjM06f35/xKkFiZ0G71Whgf/vdDVFd7H5akTaZVMDUt7zvyBY0k4
pPmIA/oC3AZ6JXkMxdsNP2h5jRY6hy4ExcVfFS1qV45PD8PZkrmwAHEY+kLYE6VS
QLi368W8v5Yoe2BnQO5qAVuvGDyuZh/385moQFFXbbYssJpUqGJqTbgrp8n07NNd
U4KOa4wQc9d1Na+dy1Y8y4iHhvy6qM2nCy4IJ2hPUzGWE/jmGrQaVG9ueSBSZWlu
YSA8Z2FyOEBwaXR0LmVkdT6IWQQTEQIAGQUCPnELcQQLBwMCAxUCAwMWAgECHgEC
F4AACgkQPDUESRn52sRUiACaAwgu3wTJeqhw4RfLU+sGS9nb+18AoImsb/IgX6DM
Yv5nHbfyBfM4B/DtuQHNBD5xC3sQBwCaqo2PgC9P7rU7BLiLniTyBdUF+El+L2EK
UDlqch/JrYmcBv/ZigKCzPUfZ9r3DVOuqQg24jrPyDB0NCUo/2Vbms6mMuMVIFKv
chA48ugJboLoC2a718I5djbfK68pZLX68wcvM3CerSj5sLcPkUrdp2+ffn6QlSog
wf31AY9LVjChkt0GS+aEorQN3xj32pjh9rRLuvKwU3TULQaqhkm6cvt5QEKYbuvt
VTDat0/h0jE2wn+3pUO3BR36f+0zwdA+QRkFEQdySoh1/AYXneYQAe2W8pt24L7v
onxwGRreQwADBgb5AYYAVHxR1FeOh8/ZoZhia4HUeZIw1VMInYqL9Z16Z9fRd8Lt
+iR1zzWe3hlyjLphqDRJdUPDueBZIfFmoTn7zGnoFyh9Ut2m2EnBhDoenKgBJNOi
DQx66LK0gb0CW4ng8DPMxCk0v2cscEiBjKn+JvRSMs0Mv3+dVeMSfZ03ScWhwGFO
W1anIsosNTeidxha3gKcCjTOFXKWDiPui1vInKvJuNQVs7VnwK38M3nEEN7e5XZQ
N82eOpJ6ieemXQ9IkGwN5yffJthoOFaF5V8YcX3kGRc84mLkpoWI/sxqohyIRgQY
EQIABgUCPnELewAKCRA8NQRJGfnaxN1pAJ0RyV5FgXLmTZm6zPR8SRiFxhvMegCe
Lh6lt6sn0V/f3vovbApIKG3exe4=
=xUMw
-----END PGP PUBLIC KEY BLOCK-----

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Yan Yan Che 2003-03-14 03:10:00 Pls Help me: access problems to tables
Previous Message Bruce Momjian 2003-03-14 02:43:57 Re: Password authentication