Re: saved passwords deleted - Mailing list pgadmin-support

I ran into this and the behavior actually make some sense -- PgAdmin can't know why the connection was rejected so it
hasto deal with the possibility that the stored might be wrong. One idea is for PgAdmin to give an option of either
reconnectingusing the stored password or to enter a new one.<br /><br /><br /><br /><div class="gmail_quote">On Wed,
Jul4, 2012 at 8:13 PM, Rohan Carly <span dir="ltr"><<a href="mailto:rohan@digins.net.au"
target="_blank">rohan@digins.net.au</a>></span>wrote:<br /><blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px#ccc solid;padding-left:1ex"> On 5/07/2012 3:57 AM, Guillaume Lelarge wrote:<br /><blockquote
class="gmail_quote"style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"> On Tue, 2012-07-03 at 14:50
+0800,Rohan Carly wrote:<br /><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc
solid;padding-left:1ex">On 17/02/2012 6:33 AM, Guillaume Lelarge wrote:<br /><blockquote class="gmail_quote"
style="margin:00 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"> On Wed, 2012-02-15 at 05:16 -0600, Michael
Shapirowrote:<br /><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc
solid;padding-left:1ex">I have taken to making a copy of the password file so that when the<br /> connection fails and
PgAdminremoves the password, I can put it back.<br /><br /></blockquote> I think I've found your issue. Here is the way
totrigger it:<br /><br /> 1. Start PostgreSQL<br /> 2. Start pgAdmin<br /> 3. Connect to your server without typing a
password(thanks to .pgpass)<br /> 4. Disconnect from your server<br /> 5. Stop PostgreSQL (not pgAdmin)<br /> 6.
Connectto your server<br />      --> error because PostgreSQL is not started<br /> 7. Start PostgreSQL<br /> 8.
Connectto your server<br />      --> pgAdmin asks for your password<br />          if you click OK here without
typingyour password, then pgAdmin<br />          records an empty password in the .pgpass file<br /><br /> The fix I
pusheda few minutes ago doesn't allow pgAdmin to record an<br /> empty password.<br /><br /> I suppose it'll fix your
issue.If you can test the current code (master<br /> or REL-1_14_0_PATCHES), that would be great.<br /><br /><br
/></blockquote>I frequently hit this bug also, using pgAdmin III v.1.14.1 on Windows.<br /><br /> It is not as complex
asstep 8 above suggests. Even if you press [Cancel],<br /> pgAdmin still forgets your password. Perhaps the solution
wouldbe to display<br /> the password prompt in this scenario, but prepopulate it with the previous<br /> password?
ThenI could just press OK and continue working.<br /><br /> I note that the passwords in<br />
C:\Users\rohan\AppData\<u></u>Roaming\postgresql\pgpass.confare in plain text.<br /><br />   From reading this thread,
andsome experimentation, I discovered that pgAdmin<br /> does not actually delete my password from the pgpass.conf
file,even though it<br /> appears that way from the frontend. Therefore my quickest workaround is to<br /> completely
closeout of pgAdmin, open it again, and double-click on the saved<br /> connection. Provided I have fixed the
connectionproblem (stopped server etc)<br /> it does not re-prompt for my password. It would still be preferable to
have<br/> this fixed though.<br /><br /></blockquote> Have you tried 1.14.3? does it still happen?<br /><br
/></blockquote>Yes, the problem is still present in 1.14.3, I just tried it this morning. As soon as I get the "server
doesn'tlisten" dialog box, I not that I will not be able to connect again without either supplying a password, or
restartingpgAdmin.<br /><br /></blockquote></div><br />