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 (an
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] http://www.postgresql.org/docs/8.3/interactive/libpq-
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 bounc