Re: [SQL] drop PW

2009-06-13 Thread Andy Shellam
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

Re: [SQL] drop PW

2009-06-13 Thread Joshua Tolley
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-