Re: saved passwords deleted

I figured this out, too. But it might be nice to offer, during a reconnect, to use the saved password (as well as
allowinga new one to be typed in). That would at least avoid people thinking that the save password was lost.<br /><br
/><br/><br /><div class="gmail_quote">On Thu, Jul 5, 2012 at 1:57 AM, Dave Page <span dir="ltr"><<a
href="mailto:dpage@pgadmin.org"target="_blank">dpage@pgadmin.org</a>></span> wrote:<br /><blockquote
class="gmail_quote"style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"> That's exactly why it does
it.<span></span><br/><br />On Thursday, July 5, 2012, Michael Shapiro wrote:<br /><blockquote class="gmail_quote"
style="margin:00 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">I ran into this and the behavior actually make
somesense -- PgAdmin can't know why the connection was rejected so it has to deal with the possibility that the stored
mightbe wrong. One idea is for PgAdmin to give an option of either reconnecting using the stored password or to enter a
newone.<br /><br /><br /><br /><div class="gmail_quote">On Wed, Jul 4, 2012 at 8:13 PM, Rohan Carly <span
dir="ltr"><<a>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 /><span class="HOEnZb"><font color="#888888">
</font></span></blockquote><spanclass="HOEnZb"><font color="#888888"><br /><br />-- <br />Dave Page<br />Blog: <a
href="http://pgsnake.blogspot.com"target="_blank">http://pgsnake.blogspot.com</a><br />Twitter: @pgsnake<br /><br
/>EnterpriseDBUK: <a href="http://www.enterprisedb.com" target="_blank">http://www.enterprisedb.com</a><br /> The
EnterprisePostgreSQL Company<br /><br /></font></span></blockquote></div><br />