Date: Sat, 13 Jun 2009 16:51:20 -0400
From: Mark Fenbers <Mark.Fenbers@noaa.gov>
Subject: drop PW
To: PostgreSQL - SQL <pgsql-sql@postgresql.org>
Message-id: <4A341148.3040102@noaa.gov>
Organization: DOC/NOAA/NWS/OHRFC
MIME-version: 1.0
Content-type: text/plain; charset=ISO-8859-1; format=flowed
Content-transfer-encoding: 7BIT
User-Agent: Thunderbird 2.0.0.21 (Windows/20090302)

I have created a new 8.3 version DB and populated it.  A specific user 
of this database (george) has been setup with a password, so that every 
time I use psql or some other utility, I need to supply this password.  
So I want to drop the password authentication.  I tried rerunning 
createuser (and just pressing Enter when prompted for the new password), 
but it complains that the user already exists.  I can't drop the user 
because this user owns the DB and all the tables.  My postgresql books 
are all for 7.x, and suggests altering the pg_shadow table (which seems 
risky to me).  I tried:
ALTER USER george PASSWORD '';
and that looked like it succeeded, but running psql again prompted me 
and when I just hit Enter, it complained that no password was supplied.

So how do I turn off being prompted for a password for george.  (I am 
aware of the security risks...)

Mark