Skip site navigation (1) Skip section navigation (2)

Re: saved passwords deleted

From: Dave Page <dpage(at)pgadmin(dot)org>
To: Vik Reykja <vikreykja(at)gmail(dot)com>
Cc: Guillaume Lelarge <guillaume(at)lelarge(dot)info>, Michael Shapiro <mshapiro51(at)gmail(dot)com>, PgAdmin Support <pgadmin-support(at)postgresql(dot)org>
Subject: Re: saved passwords deleted
Date: 2012-02-14 21:25:44
Message-ID: CA+OCxoy9hW4apwRtYfkzLM-8xY3rc9wpPcxRBhr=P46T7xG25g@mail.gmail.com (view raw or flat)
Thread:
Lists: pgadmin-support
On Tue, Feb 14, 2012 at 9:21 PM, Vik Reykja <vikreykja(at)gmail(dot)com> wrote:
> On Tue, Feb 14, 2012 at 22:03, Guillaume Lelarge <guillaume(at)lelarge(dot)info>
> wrote:
>>
>> On Mon, 2010-11-08 at 16:16 +0100, Guillaume Lelarge wrote:
>> > Le 06/11/2010 22:35, Guillaume Lelarge a écrit :
>> > > Le 05/11/2010 17:18, Michael Shapiro a écrit :
>> > >> I noticed that if I have a problem connecting to a server for which I
>> > >> have a
>> > >> saved password, the entry in pgpass.conf is deleted.
>> > >> When I later succeed in connecting, the server then prompts for a
>> > >> password
>> > >> (and the pgpass.conf entry is added back).
>> > >>
>> > >> Is it possible to not delete the entry if the connection fails?
>> > >>
>> > >
>> > > Right now, no. And I can't find this dialog now, must be too tired.
>> > >
>> > > But, yes, it could probably be a good idea to add such an option.
>> > >
>> >
>> > I also created a ticket to remind us to work on this dialog.
>> >
>>
>> I tried quite some time to reproduce the issue tonight, and failed to do
>> so. The only time it removes the password is when I unchecked the "Store
>> password" checkbox, which appears to be a valid behaviour.
>>
>> Unless you're able to show me how to do this, I'm afraid we won't do
>> anything on that matter (because there is nothing to do).
>
>
> This is how it happens to me (on Windows at work, I haven't tried on linux
> at home and I don't have a mac):
>
> 1. connect to server, save password
> 2. disconnect from server
> 3. stop server
> 4. connect to server (fails, of course)
> 5. start server
> 6. connect to server
>
> pgAdmin asks for my password

That's intentional. A failed connection attempt causes the password to
be dropped to prevent you getting stuck in a situation where you
cannot login without manually editing the file to get round some
random authentication issue.


-- 
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

In response to

Responses

pgadmin-support by date

Next:From: Vik ReykjaDate: 2012-02-14 21:33:05
Subject: Re: saved passwords deleted
Previous:From: Vik ReykjaDate: 2012-02-14 21:21:24
Subject: Re: saved passwords deleted

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group