From: | Andy Shellam <andy-lists(at)networkmail(dot)eu> |
---|---|
To: | Mark Fenbers <Mark(dot)Fenbers(at)noaa(dot)gov> |
Cc: | PostgreSQL - SQL <pgsql-sql(at)postgresql(dot)org> |
Subject: | Re: drop PW |
Date: | 2009-06-13 23:56:18 |
Message-ID: | 4A343CA2.4040900@networkmail.eu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Mark,
As Joshua said, you can modify pg_hba.conf. What's happening is
PostgreSQL is configured to require a password for the IP address that
user is connecting from, but you're not supplying one. Set that user
and the IP address they connect from to "trust" security in pg_hba.conf
and bounce PostgreSQL.
An alternative approach is to add the required password to your user's
.pgpass file however I've never used those so cannot comment.
Andy
Mark Fenbers wrote:
> 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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Zdravko Balorda | 2009-06-15 08:14:46 | PHP pg_escape_string |
Previous Message | Joshua Tolley | 2009-06-13 20:55:01 | Re: drop PW |