Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 6023B476492 for ; Thu, 3 Oct 2002 11:24:35 -0400 (EDT) Received: from mail.virginia.edu (mail.Virginia.EDU [128.143.2.9]) by postgresql.org (Postfix) with SMTP id 66406476482 for ; Thu, 3 Oct 2002 11:24:34 -0400 (EDT) Received: from smtp.mail.virginia.edu by mail.virginia.edu id ac18764; 3 Oct 2002 11:24 EDT Received: from jlk3xpc (d-128-19-222.bootp.Virginia.EDU [128.143.19.222]) by smtp.mail.Virginia.EDU (8.11.6/8.11.6) with SMTP id g93FOYV44132 for ; Thu, 3 Oct 2002 11:24:35 -0400 Message-ID: <00da01c26af1$48cd4570$de138f80@virginia.edu> From: Jodi Kanter To: Postgres Admin List Subject: password encryption Date: Thu, 3 Oct 2002 11:26:45 -0400 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_00D7_01C26ACF.C14786E0" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4522.1200 X-MIMEOLE: Produced By Microsoft MimeOLE V5.50.4522.1200 X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200210/10 X-Sequence-Number: 5868 This is a multi-part message in MIME format. ------=_NextPart_000_00D7_01C26ACF.C14786E0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable We are currently using the pg_passwd utility to encrypt passwords. Someone = here told me that I can now encrypt passwords within postgresql so that the= y are not stored in plain text in the pg_shadow file. Is this true? I cannot seem to find any mention of it in my postgresql book= s but it's quite possible that they were all written prior to the release o= f 7.2. Thanks Jodi=20 _______________________________ Jodi L Kanter BioInformatics Database Administrator University of Virginia (434) 924-2846 jkanter@virginia.edu =20 =20 =20 ------=_NextPart_000_00D7_01C26ACF.C14786E0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

We are currently using the pg_passwd ut= ility=20 to encrypt passwords. Someone here told me that I can now encrypt passwords= =20 within postgresql so that they are not stored in plain text in the pg_shado= w=20 file.

Is this true? I cannot seem to find any= =20 mention of it in my postgresql books but it's quite possible that they were= all=20 written prior to the release of 7.2.

Thanks

Jodi

_______________________________
Jodi=20 L Kanter
BioInformatics Database Administrator
University of=20 Virginia
(434) 924-2846
jkanter@virginia.edu

<= /DIV> ------=_NextPart_000_00D7_01C26ACF.C14786E0--