Received: from localhost (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id 7EF5664FCD8
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Fri,  5 Dec 2008 11:42:33 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 30410-04 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Fri,  5 Dec 2008 11:42:30 -0400 (AST)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from rv-out-0506.google.com (rv-out-0506.google.com
 [209.85.198.238])
	by mail.postgresql.org (Postfix) with ESMTP id B0D0165025B
	for <pgsql-admin@postgresql.org>; Fri,  5 Dec 2008 11:42:30 -0400 (AST)
Received: by rv-out-0506.google.com with SMTP id b25so43006rvf.43
	for <pgsql-admin@postgresql.org>; Fri, 05 Dec 2008 07:42:28 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:received:received:message-id:date:from:to
	:subject:mime-version:content-type:content-transfer-encoding
	:content-disposition;
	bh=Fvlj2aKLpaj6mVOCEKUED7vXCZ9P2NKd6M6cIWmPbw4=;
	b=Uo+BaD23jJOOnWt0pRfqTRDCnOkoDgGTkB+0p2W+WtWzIeBUhY+52A/2oJsKWOpJ4y
	+jYfEhpmQCvpn3url6dkB+IbBJIsFRYKSYsrX+xx8Ags6UhrFE/KhwI8pIzeVKVunlr2
	YOu9NTDvAU5OBnuL0mDbcYuX1bCe26bDuWXUk=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=message-id:date:from:to:subject:mime-version:content-type
	:content-transfer-encoding:content-disposition;
	b=x4jamMjMONCZ5r3dy8xWRfYCWIe1OaL08vCHgIZsYL7vkvKO5sVFcR1k/wk1NMCe7q
	ZZw8/PxbCzCV8CpvE+nihgZoeKdGjZG/XLlgy97zdbLmLXsWfGKY5LqKw4qbH0ySov5u
	6mcG7O6Gojmuasvxl8xSNZaMG8g2BNmd9OT3M=
Received: by 10.140.250.14 with SMTP id x14mr47465rvh.278.1228491748725;
	Fri, 05 Dec 2008 07:42:28 -0800 (PST)
Received: by 10.140.185.21 with HTTP; Fri, 5 Dec 2008 07:42:28 -0800 (PST)
Message-ID: <6835906b0812050742t279c9f04r18218cff3d79eb78@mail.gmail.com>
Date: Fri, 5 Dec 2008 10:42:28 -0500
From: "Dan Scott" <danieljamesscott@gmail.com>
To: pgsql-admin@postgresql.org
Subject: Change user password
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none
X-Spam-Level: 
X-Archive-Number: 200812/72
X-Sequence-Number: 30905

Hi,

Is is possible to modify a user password using a command line script?
I know about the ALTER USER command from within the client, but this
looks like it's quite insecure, storing the password in the history. I
know it's possible to insert the encrypted password with ALTER USER
but that means generating the hash elsewhere. A simple 'alteruser -P
username' which then prompts for the user password would be nice. Does
this exist?

Thanks,

Dan Scott