Thread: Unable to connect existing PGAdmin to existing PostgreSQL Db
<div class="WordSection1"><p class="MsoNormal">Hi ,<p class="MsoNormal"> <p class="MsoNormal">I have come across this issueall the time. <p class="MsoNormal"> <p class="MsoNormal">I reinstalled and it works for a while. Once the computer rebooted,it appeared again. <p class="MsoNormal"> <p class="MsoNormal">Regards,<p class="MsoNormal"> <p class="MsoNormal"><spanstyle="font-size:10.0pt">Naixian (Nancy) Zhang</span><p class="MsoNormal"><span style="font-size:10.0pt">ProductSpecialist | Global Client Solutions</span><p class="MsoNormal"><span style="font-size:10.0pt">RevereData</span><p class="MsoNormal"><span style="font-size:10.0pt">60 East 42nd Street, Suite716</span><p class="MsoNormal"><span style="font-size:10.0pt">New York, NY 10165</span><p class="MsoNormal"><span style="font-size:10.0pt">Office:(212) 405 3980 x210<br /> Mobile: (216) 533 7395</span><p class="MsoNormal"><span style="font-size:10.0pt"><ahref="http://www.reveredata.com/"><span style="color:blue">www.reveredata.com</span></a></span><pclass="MsoNormal"> </div> This message is intended only for theuse of the Addressee and may contain information that is PRIVILEGED and/or CONFIDENTIAL. This email is intended only forthe personal and confidential use of the recipient(s) named above. If the reader of this email is not an intended recipient,or you have received this email in error, you are hereby advised that any review, dissemination, distribution orcopying is strictly prohibited. If you have received this email in error, please notify the sender immediately by returnmail and permanently delete the copy you received.
On Thu, 2012-07-12 at 18:40 +0000, Zhang, Nancy wrote: > Hi , > > I have come across this issue all the time. > > I reinstalled and it works for a while. Once the computer rebooted, it appeared again. > Well, without any kind of error messages, how do you want us to help you? -- Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com
On Mon, 2012-07-16 at 12:50 +0000, Zhang, Nancy wrote: > Thank you Gaullaume, > > > > Here is the screenshot of the issue: > If it continues to ask you for the password, it is because you don't give him the right password. -- Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com
<div class="WordSection1"><p class="MsoPlainText">Thank you Gaullaume, <p class="MsoPlainText"> <p class="MsoPlainText">Hereis the screenshot of the issue:<p class="MsoPlainText"><img height="447" id="Picture_x0020_1" src="cid:image001.jpg@01CD6330.1A3085A0"width="682" /><p class="MsoPlainText"> <p class="MsoPlainText">I do remember thepassword correctly, but I never can get passed this setting. <p class="MsoPlainText"> <p class="MsoPlainText">Thanks.<pclass="MsoPlainText"> <p class="MsoPlainText">Regards,<p class="MsoPlainText"> <p class="MsoPlainText">Naixian(Nancy) Zhang<p class="MsoPlainText">Product Specialist | Global Client Solutions<p class="MsoPlainText">RevereData<p class="MsoPlainText">60 East 42nd Street, Suite 716<p class="MsoPlainText">New York, NY10165<p class="MsoPlainText">Office: (212) 405 3980 x210<p class="MsoPlainText">Mobile: (216) 533 7395<p class="MsoPlainText">www.reveredata.com<pclass="MsoPlainText"> <p class="MsoPlainText"> <p class="MsoPlainText">-----OriginalMessage-----<br /> From: Guillaume Lelarge [mailto:guillaume@lelarge.info] <br /> Sent:Saturday, July 14, 2012 8:42 AM<br /> To: Zhang, Nancy<br /> Cc: pgadmin-support@postgresql.org<br /> Subject: Re: [pgadmin-support]Unable to connect existing PGAdmin to existing PostgreSQL Db<p class="MsoPlainText"> <p class="MsoPlainText">OnThu, 2012-07-12 at 18:40 +0000, Zhang, Nancy wrote:<p class="MsoPlainText">> Hi ,<p class="MsoPlainText">><p class="MsoPlainText">> I have come across this issue all the time.<p class="MsoPlainText">><p class="MsoPlainText">> I reinstalled and it works for a while. Once the computer rebooted,it appeared again.<p class="MsoPlainText">> <p class="MsoPlainText"> <p class="MsoPlainText">Well, without anykind of error messages, how do you want us to help you?<p class="MsoPlainText"> <p class="MsoPlainText"> <p class="MsoPlainText">--<pclass="MsoPlainText">Guillaume<p class="MsoPlainText"><a href="http://blog.guillaume.lelarge.info"><spanstyle="color:windowtext; text-decoration:none">http://blog.guillaume.lelarge.info</span></a><pclass="MsoPlainText"><a href="http://www.dalibo.com"><spanstyle="color:windowtext; text-decoration:none">http://www.dalibo.com</span></a><p class="MsoPlainText"> </div>This message is intended only for the use of the Addressee and may contain information that isPRIVILEGED and/or CONFIDENTIAL. This email is intended only for the personal and confidential use of the recipient(s) namedabove. If the reader of this email is not an intended recipient, or you have received this email in error, you are herebyadvised that any review, dissemination, distribution or copying is strictly prohibited. If you have received this emailin error, please notify the sender immediately by return mail and permanently delete the copy you received.
On Mon, 2012-07-16 at 13:45 +0000, Zhang, Nancy wrote: > It is not that simple. > > Once I installed PostgreSQL, it run well for a certain amount of time, then oneday, that window pop up, asking the password. > Something must be happening on your PC. > And because I have come across this several times, so I put down the password and entered, making sure the password isexactly the same as the one I set up when installing PostgreSQL. > > Some guy at my firm told me it might be caused by the security setting of my computer... > > Any more hint? > No, I don't see how a security setting of your computer may be involved. -- Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com
On Mon, 2012-07-16 at 21:59 +0000, Zhang, Nancy wrote: > So what Should I do? Tons of thanks! > Please, send the emails to the mailing list, not only me. What should you do? I have no idea. All I know is that it works, and suddenly it doesn't remember your password. There's nothing I can do about this. If you find why it forgets your password, then I may be able to do something. -- Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com
On 17/07/2012 07:57, Guillaume Lelarge wrote: > On Mon, 2012-07-16 at 21:59 +0000, Zhang, Nancy wrote: >> So what Should I do? Tons of thanks! >> > > Please, send the emails to the mailing list, not only me. > > What should you do? I have no idea. All I know is that it works, and > suddenly it doesn't remember your password. There's nothing I can do > about this. If you find why it forgets your password, then I may be able > to do something. Passwords are stored on Windows under <your home directory>/AppData/Roaming/postgresql/pgpass.conf - could something be deleting it behind your back? Ray. -- Raymond O'Donnell :: Galway :: Ireland rod@iol.ie
Thank you Ray. There isn't any file named pgpass.conf in my computer after my searching attempt. Is there any other reasons? And is there a way that I delete in a clean way and resintall it? Regards, Naixian (Nancy) Zhang Product Specialist | Global Client Solutions Revere Data 60 East 42nd Street, Suite 716 New York, NY 10165 Office: (212) 405 3980 x210 Mobile: (216) 533 7395 www.reveredata.com -----Original Message----- From: Raymond O'Donnell [mailto:rod@iol.ie] Sent: Tuesday, July 17, 2012 8:00 AM To: Guillaume Lelarge Cc: Zhang, Nancy; pgadmin-support@postgresql.org Subject: Re: [pgadmin-support] Unable to connect existing PGAdmin to existing PostgreSQL Db On 17/07/2012 07:57, Guillaume Lelarge wrote: > On Mon, 2012-07-16 at 21:59 +0000, Zhang, Nancy wrote: >> So what Should I do? Tons of thanks! >> > > Please, send the emails to the mailing list, not only me. > > What should you do? I have no idea. All I know is that it works, and > suddenly it doesn't remember your password. There's nothing I can do > about this. If you find why it forgets your password, then I may be > able to do something. Passwords are stored on Windows under <your home directory>/AppData/Roaming/postgresql/pgpass.conf - could something be deleting it behind your back? Ray. -- Raymond O'Donnell :: Galway :: Ireland rod@iol.ie This message is intended only for the use of the Addressee and may contain information that is PRIVILEGED and/or CONFIDENTIAL.This email is intended only for the personal and confidential use of the recipient(s) named above. If the readerof this email is not an intended recipient, or you have received this email in error, you are hereby advised that anyreview, dissemination, distribution or copying is strictly prohibited. If you have received this email in error, pleasenotify the sender immediately by return mail and permanently delete the copy you received.
On 17/07/2012 14:14, Zhang, Nancy wrote: > Thank you Ray. > > There isn't any file named pgpass.conf in my computer after my > searching attempt. Is there any other reasons? And is there a way > that I delete in a clean way and resintall it? If there's no pgpass.conf file, then that's why you're being asked for your password - it hasn't been saved. You should try entering the password and ticking the box to save it, and see if the pgpass.conf gets created. If it doesn't, you need to figure out why (permissions maybe?). If it does get created, and then is deleted at a later point, you need to find out what's deleting it; from what I understand it's unlikely to be pgAdmin. Ray. -- Raymond O'Donnell :: Galway :: Ireland rod@iol.ie
On 17/07/2012 17:37, Raymond O'Donnell wrote: > On 17/07/2012 14:14, Zhang, Nancy wrote: >> Thank you Ray. >> >> There isn't any file named pgpass.conf in my computer after my >> searching attempt. Is there any other reasons? And is there a way >> that I delete in a clean way and resintall it? > > If there's no pgpass.conf file, then that's why you're being asked for > your password - it hasn't been saved. > > You should try entering the password and ticking the box to save it, and > see if the pgpass.conf gets created. If it doesn't, you need to figure > out why (permissions maybe?). If it does get created, and then is > deleted at a later point, you need to find out what's deleting it; from > what I understand it's unlikely to be pgAdmin. One other though - did someone maybe change the password on the server? - i.e. the PostgreSQL server? Ray. -- Raymond O'Donnell :: Galway :: Ireland rod@iol.ie