Re: saved passwords deleted

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