| Lists: | pgsql-general |
|---|
| From: | glaucomag <glaucomag(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | pgadmin save password |
| Date: | 2010-01-08 20:22:03 |
| Message-ID: | 2f1bcad1-62f3-41ef-aa00-85fe173d8cde@k19g2000yqc.googlegroups.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general |
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
| From: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
|---|---|
| To: | glaucomag <glaucomag(at)gmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: pgadmin save password |
| Date: | 2010-01-08 21:53:56 |
| Message-ID: | 4B47A974.2010804@lelarge.info |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general |
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
| From: | José María Terry Jiménez <jtj(at)tssystems(dot)net> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: pgadmin save password |
| Date: | 2010-01-09 11:09:28 |
| Message-ID: | 4B4863E8.1090303@tssystems.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general |
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