From: Mark Fenbers <Mark.Fenbers@noaa.gov>
To: PostgreSQL - SQL <pgsql-sql@postgresql.org>
Subject: drop PW
Date: Sat, 13 Jun 2009 16:51:20 -0400
Message-ID: <4A341148.3040102@noaa.gov> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: Mark.Fenbers@noaa.gov
Subject: Re: drop PW
In-Reply-To: <4A341148.3040102@noaa.gov>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox