Received: from orion3.ori-ind.com (IDENT:root@[206.81.197.190]) by hub.org (8.9.3/8.9.3) with ESMTP id MAA33398 for ; Wed, 2 Feb 2000 12:04:45 -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 JAA25317 for ; Wed, 2 Feb 2000 09:15:23 -0800 Message-Id: <3.0.1.32.20000202090510.00ae78e0@ori-ind.com> X-Sender: ken@ori-ind.com X-Mailer: Windows Eudora Pro Version 3.0.1 (32) Date: Wed, 02 Feb 2000 09:05:10 -0800 To: pgsql-interfaces@postgreSQL.org From: "Ken J. Wright" Subject: pg_pwd trouble 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 creates a file similar to /etc/passwd including the username and an encrypted password. Known problem? Ken