pgadmin save password

Le 08/01/2010 21:22, glaucomag a �crit :

Hi, I've a problem with pgadmin. If I access to database with user X
and I save password, when I access to database from shell (psql)
password is not required. Of course pg_hba.conf is:

local database X md5

If I don't save password in pgadmin, it's ok (psql required password).
The question is this: is it possible that pgadmin save password also
for psql? And where pgadmin save password?

pgadmin creates the .pgpass file that all libpq programs use to easily
connect a user to a database.

--
Guillaume.
http://www.postgresqlfr.org
http://dalibo.com

glaucomag escribi�:

Hi, I've a problem with pgadmin. If I access to database with user X
and I save password, when I access to database from shell (psql)
password is not required. Of course pg_hba.conf is:

local database X md5

If I don't save password in pgadmin, it's ok (psql required password).
The question is this: is it possible that pgadmin save password also
for psql? And where pgadmin save password?

Thank you

pgAdmin saves passwords in ~/.pgpass

http://www.pgadmin.org/docs/1.4/pg/libpq-pgpass.html

Best,

=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Scanned with Copfilter Version 0.84beta3a (ProxSMTP 1.6)
AntiVirus: ClamAV 0.95.2/10275 - Sat Jan 9 02:06:46 2010
by Markus Madlener @ http://www.copfilter.org