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
On Sat, Jun 13, 2009 at 04:51:20PM -0400, Mark Fenbers wrote:
So how do I turn off being prompted for a password for george. (I am
aware of the security risks...)
Create a .pgpass file[1], or modify pg_hba.conf[2]
- Josh / eggyknap
[1]
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