Received: from orion3.ori-ind.com (IDENT:root@[206.81.197.190]) by hub.org (8.9.3/8.9.3) with ESMTP id QAA16116 for ; Tue, 22 Feb 2000 16:09:11 -0500 (EST) (envelope-from ken@ori-ind.com) Received: from ken (stimpy.ori-ind.com [192.168.61.96]) by orion3.ori-ind.com (8.8.7/8.8.7) with SMTP id NAA06145 for ; Tue, 22 Feb 2000 13:09:04 -0800 Message-Id: <3.0.1.32.20000222130908.00b9f950@ori-ind.com> X-Sender: ken@ori-ind.com X-Mailer: Windows Eudora Pro Version 3.0.1 (32) Date: Tue, 22 Feb 2000 13:09:08 -0800 To: pgsql-interfaces@postgreSQL.org From: "Ken J. Wright" Subject: pg_pwd problem, 2nd try Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" If I use the ALTER USER sql statement, the file pg_pwd gets written in an older plain text format & the user can no longer authenticate. However, using pg_passwd from the command line reates a file similar to /etc/passwd including the username and an encrypted password. Known problem? Ken