Thread: pgadmin save password

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

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